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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Installed SQL Server 2005 - what is server name?

Author  Topic 

dreamweaver547
Starting Member

6 Posts

Posted - 2009-10-10 : 17:04:40
I'm new to SQL Server so I might be on these forums again.

Installed SQL Server 2005 Express Edition with Advanced Services SP3 (download without registering).

Now my basic problem is in SQL Management Studio Express. The server type is Database Engine, Authentication is Windows Authentication.

What do I type in for Server name and what are the differences in the Server types (Database Engine or SQL Compact Edition) and Authentication types (Windows or SQL Server)?

Thanks.

nathans
Aged Yak Warrior

938 Posts

Posted - 2009-10-11 : 02:34:32
If you installed using the wizard's defaults then you should be able to connect using:

Server Type: Database Engine
Server Name: .\SqlExpress (or, YourHostName\SqlExpress)

Please post back if you run into any trouble.
Go to Top of Page

dreamweaver547
Starting Member

6 Posts

Posted - 2009-10-11 : 03:14:04
Yeah, I tried this but no luck and get this message:

TITLE: Connect to Server
------------------------------

Cannot connect to (full computer name.)\sqlexpress.

------------------------------
ADDITIONAL INFORMATION:

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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


I'm also looking at another line of investigation and am wondering whether these problems are because I didn't register the application with Microsoft.

I get this message when looking at the SQL Server Surface Area Configuration for Services and Connections:

TITLE: Surface Area Configuration
------------------------------

No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)

------------------------------
BUTTONS:

OK
------------------------------
Go to Top of Page

dreamweaver547
Starting Member

6 Posts

Posted - 2009-10-14 : 12:37:38
This problem was resolved by reinstalling SQL Server and setting the instance name to default instance and not named instance.

Also in Server name I put a .(DOT)
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2009-10-14 : 14:40:31
good for you



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -