February 10, 2011 at 3:22 pm
I am having some problems when trying to inititate a connection to start using sql server 2005. i need to establish a connection before i do anything, but I will not connect to a server. I want to install it on a local machine. I attempted to use my computer name as the server name which was stated in a tutorial and I tried but no successful results. Does anyone have an idea of what the problem is? i found out two possible problems but i wud like feedback from u all d experienced experts.
thanks
nikki
February 10, 2011 at 3:34 pm
Connecting to server depends upon how you have installed it.
Usually if have gone with the default settings and have not named the SQL server instance then
you should be connecting using YOUR Machinename\MSSQLSERVER
or if you have given the name to the SQL server instance then you should connect using machinename\instancename
Or on the connection screen, try the following
Server Type Database Engine
Server Name local
Authentication Windows Authentication
:w00t:
February 10, 2011 at 3:50 pm
thanks i will try that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply