Question:
I am trying to set up server.
I have installed SQL 2005 standard.
And now I am trying to log in through TCP/IP..
I went to SQL Server Config Mgmt and Enabled TCP/IP
Double checked IP address and made it Active and enabled it.
Now I tried to connect Management Studio using that IP and it doesnt log in.
Does anyone knows good links to guidelines on how to set up server, login etc.
Thank you very muchDid you restart the service ? See my screencast on www.sqlserver2005.de . You have to restart to make changes effective.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
check your surface area configuration for connection. check the ooption that says you want to accept connection from a remote connection. The only connection allowed by default is local
start>programs>micrsoft sql server 2005>configuration tools>surface area configuration>configuration for services and connection>remote connection>local and remote connection
from there you'll know what to do
No comments:
Post a Comment