3 พฤษภาคม 2555 9:33
Hi, i have configured MSSQL 2008 and have setup a named instance SPSQL.
I am trying to allow remote connections to this instance. My server name is SERVER
However, the program and client will not connect to this SQL Server. I can sucessfully logon to the instance with windows authentication on the SERVER (localhost)
I have followed this guide
specified a port in configuration manager, opened it in firewall, and also added sqlservr.exe for my instance as a program. None of these have worked!
Has anyone any ideas?
3 พฤษภาคม 2555 9:45
3 พฤษภาคม 2555 9:50
Thanks for your reply.
I just checked and it is using a backslash, i typed it incorrecly
But still no connection.
4 พฤษภาคม 2555 5:14
Have you use the correct server and instance name?
You can look up the instance name in Service Manager (services.msc), there you will find an entry like "SQL Server (SPSQL)"; the instance name is placed in brackets.
4 พฤษภาคม 2555 5:30
Thanks, but yes i have definitly used the correct instance name. I checked it!