Groups | Blog | Home
all groups > sql server connect > february 2006 >

sql server connect : XP as Server...


NWO
2/4/2006 12:59:49 PM
Hello.

I installed SQL Server 2005 on my XP Professional personal PC last night.
Everything loaded OK. But when I tried to access some of the servces, I was
prompted to connect to a server and the Server Name was blank. I guess my
question is how do I set up my XP Professional to run as a server? I'm
loading the SQL Server 2005, in addtional to Visual Studio 2005, as a test to
learn the products. Is there another way around this - please advise (keep
it simple please).

NWO
2/6/2006 1:33:26 PM
Come on, I know somebody out there smarter than me has a solution for my
question, If my question is not stated in an understandable manner, please
advise and I will restste.

Thank you.

NWL :)

[quoted text, click to view]
Roger Wolter[MSFT]
2/6/2006 2:26:39 PM
If you are trying to connect to the SQL Server running on the same box as
you are running the tool, the server name is . if SQL Server is running as
the default instance and .\sqlexpress if you installed the SQL Express
edition.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

NWO
2/6/2006 8:36:09 PM
Thank you Roger.

I'm using SQL Servor Enterprise Edition (Eval 180 days).

The period did not work and I am running SQL 2005 on the same box as XP.

Any other ideas to get me going here?

Mark :)


[quoted text, click to view]
Roger Wolter[MSFT]
2/6/2006 10:05:20 PM
dot, localhost, or the hostname of your server should all work for a local
connection. I assume you have something else going on. What kind of error
do you get and what is in the error log?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

NWO
2/6/2006 10:40:27 PM
Error 40: cannot conect to server.

Here are the steps that I follow:

* Open Server Management Studio
* Server type defaults to Database Engine
* Server name: . or localhost dosn't work
* Auth: Windows Auth.
* Press Connect
Error ocurs after about 30 seconds.

I installed the full product last night and didn't receive any install errors.

Nothing seems to be working for me!

NWO :(

[quoted text, click to view]
Roger Wolter[MSFT]
2/7/2006 8:59:12 AM
It sure sounds like you installed a named instance instead of the default
instance. Try running "sqlcmd" from a cmd window. Also try using the SQL
Sever Configuration Manager utility to look at "SQL Native Client
Configuration/Client Protocols" to make sure Shared Memory and Named Pipes
are enabled. Also check the error log at: C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG to see if there are any errors. If the Windows
user you are connecting as an administrator on the box?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

AddThis Social Bookmark Button