July 29, 2009 at 4:32 am
hi ,
i have added a new instance into exisitng server(d2tba02 sql server 2005 developer edition with SP2 ).
I m able to connect it with server's physical machine but cannot able to login from my machine ( client ) , some body told me that i havent set its TCP/IP port but i didnt get any TCP/IP port setting option , while installing sql server instance.
when ever i try to login from my machine , its giving
"Error : 28 , server doesnt support requested protocol."
While checking into Sql server Configuration manager >> SQl server 2005 Network Configuration
it is not showing blade for "Protocols for d2tba02\report_dev"
please help me ASAP
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 29, 2009 at 4:38 am
Can you try following.
SQL server 2005 Surface Area Configuration -> change the instance name by using the "change computer" link -> Surface Area Configuration for Services and Connections - > Database engine -> Remote Connections
And enable "local and remote connections" from there.
-Vikas Bindra
July 29, 2009 at 4:50 am
Thanks for immediate response 🙂
yes,
I enabled those settings but still i am not able to see new instance in sql server network configuration.
because of that i couldnt login through my local machine( client machine)
bhuvnesh
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 29, 2009 at 5:03 am
I am not sure about why the instance is not coming up in the network configuration option
But, have you enabled both TCP/IP and named pipes for the named instance?
-Vikas Bindra
July 29, 2009 at 5:08 am
yes , i had enabled those setting earlier 🙁
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 29, 2009 at 6:28 am
Two instances on a machine do have two different ports. They can be dynamically assigned. You say you have TCPIP enabled. Do you have the SQL Server Browser service running?
You can check to see which port the service is running on by looking at protocols properties for that instance.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 29, 2009 at 6:35 am
Start>Program>Microsoft SQL Server 2005> Configuration Tool>SQL Server configuration Manager>SQL Server 2005 Network Configuration>Protocols for MSSQL Server and make sure that TCP/IP protocol is enabled and VIA protocol is disabled.
Scroll through SQL Native Client Configuration to make sure the same.
Also, check under SQL Server 2005 Services and if you have installed your instances correctly you should be able to see the SQL Server service for your instance in question.
July 29, 2009 at 6:39 am
I would first check whether TCP/IP is enabled as Vishal said in earlier post.
TCP/IP is dynamically assigned and is not asked during installation.
July 29, 2009 at 6:54 am
Hi,
i just observed that i have used local login account(limited priviledges), so can this be issue ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 29, 2009 at 9:57 pm
bhuvnesh.dogra (7/29/2009)
Hi,i just observed that i have used local login account(limited priviledges), so can this be issue ?
Where? for the services to run under?
Check that for the instances you have installed if your services are running account should be fine (atleast for you to see the instances and connect with) it will not create any problem till you are working on a network task.
July 29, 2009 at 10:49 pm
hi vishal ,
one thing i would like to share with u, if i see "sql server surface area configuration " i can see there new instance ...thats some thing strange.
Please tell me one thing ..how can i check the instance in registry ..i dont know where this registry folder lies ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 29, 2009 at 10:59 pm
Why to check the registry if your instance services are running?
anyway, you can check here:
HKEY_LOCAL_MACHIN > SOFTWARE > MICROSOFT > Microsoft SQL Server > Instance Names
and also the below to check the services:
HKEY_LOCAL_MACHIN > SYSTEM > CurrentControlSet > Services >
MSSQLSERVER (you should be able to see like MSSQL.1, MSSQL.2 etc...
July 29, 2009 at 11:04 pm
bhuvnesh.dogra (7/29/2009)
one thing i would like to share with u, if i see "sql server surface area configuration " i can see there new instance ...thats some thing strange.
Nothing strange in it. Its a general behaviour of SQL Server SAC.
If you have installed a name instance, in SAC if you go to Surface Area Configuration for Services and Connections > View by Instances, It should show you all the instances you have including SSAS, SSIS, SSB etc...
July 30, 2009 at 1:29 am
Thanks
While browsing to HKEY_LOCAL_MACHINE>>software>>microsoft>>microsoft sql server
in the instance folder "REPORT_DEV"
REPORT_DEV>>MSSQLSERVER>>SuperSocketNetlib folder
therer should be one more folder "Tcp"
can u please tell me how can i generate it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 30, 2009 at 1:59 am
Why to play with registry, the TCP directory created by the setup itself whenever you install a default or a named instance of SQL server.
Remember, you can put yourself in more problem with existing instances also if you are going that. (I hope you are on R&D machine)
However, if you want to do it here you go:
1) right click > New > Key (name this a TCP)
2) select this key in registry and the right side window do a right click again New>String value >provide the valuename as "DisplayName" and Value Data as "TCP/IP"
3) you have now to create the below Binary values (in this example I have took the value data as a sample which could be different in your case)
i) Enabled -- value data 1 and base = hexadecimal
ii) KeepAlive --value data 7530 and base = hexadecimal
iii)ListenOnAllIPs--value data 1 and base = hexadecimal
iv)NoDelay--value data 0 and base = hexadecimal
Now go to the TCP key>select it and again right click >NEw>Key and name it as IP1 and now select the key IP1 to create the value:
Create the string value first
i) DisplayName - Value data="Specific IP Address"
ii)IpAddress-Value data=
iii)TcpDynamicPorts - Value data - if you have DHCP set to on specify some ports separated by ','
iv)TcpPort: Value data = 1433
you have to repeat these steps for the number of instances you have.
WARNING: I recommend, to repaire your instance installation rather repairing your registry.
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply