Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Oliver wang
Yak Posting Veteran
50 Posts |
 Posted - 2011-04-11 : 03:48:41
|
| Hi everyone,I installed a SQL Server 2008 on a box which is in a workgroup. I have changed the unthentication mode to "Mixed". But if i want to logon the server with a sql user(eg. "sa"), I get a error message as below: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)Can anybody have any idea for this? Thanks for your help.regards,Oliver |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-11 : 08:40:07
|
| are you sure that SQL Server Service running ?--------------------------http://connectsql.blogspot.com/ |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-11 : 08:43:02
|
| start --> SQL Server 2008 --> SQL Server Configuration Manager ===> SQL Server(MSSQLSERVER)--------------------------http://connectsql.blogspot.com/ |
|
|
|
Oliver wang
Yak Posting Veteran
50 Posts |
Posted - 2011-04-13 : 05:28:29
|
| hi lionofdezert,you won't believe what happened here. Actually on the same server, there is another default instance which I can just connect to perfectly from client side. But i just can't connect to the named instance if I input "IP address\instance_name" for server name. Now I just stop the default instance, change the port of named instance to 1433 and just use IP address for server name. I logon successfully(I didin't change any other config). What a weird thing. Does any body have idea on this? Thanks.Regards,Oliver |
|
|
|
kanagarajnm
Starting Member
2 Posts |
Posted - 2011-04-13 : 07:42:26
|
| Change the Port number for the named instance and try to connect by using IP Address and Port number for the new named instance. Probably you haven't enabled the Named Pipes for your new instance. |
|
|
|
|
|
|
access a server in workgroup