issue with SQL Server 2005 - SQL Server Forums

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

issue with SQL Server 2005

Author

Topic

associates
Starting Member

31 Posts

Posted - 2006-07-27 : 00:26:49

Hi

I'm new to SQL Server and would like to get a feel of it. So I went to download and had installed the SQL Server 2005 Express Edition.

Now, i'd like to run and see the GUI interface but can't find it. The service is running.

I went to start->all programs->microsoft SQL server 2005->(only)configuration tools
In that tools, there are three options
1. SQL Server Configuration Server
2. SQL Server Error and Usage Report
3. SQL Server Surface Area configuration

Am i missing something here? I think i need some guidance here.

Your help is greatly appreciated. Thank you in advance

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-07-27 : 02:37:19

The thing is...SQL Server Express Edition doesn't come with a GUI. Go to this link http://msdn.microsoft.com/sql/express/ and under "Product information" on the right you will be able to download "Management Studio Express". It will get you a little bit further I suppose...

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

associates
Starting Member

31 Posts

Posted - 2006-07-30 : 23:30:19

Hi Lumbago,

Thank you for your reply.

Now i've got the management studio express running. Then, i went to upsize a database .mdb hoping that i could convert into SQL Server. I got the following error after finishing the upsize wizard.
connection failed:
SQL State: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())
Connection failed:
SQL State: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied

I think this is a connection issue. I was wondering if someone might be able to help overcome this issue.

Thank you in advance

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-07-31 : 03:35:50

This is most definetly a connection issue. What are you trying to connect to? If this is the only sql server installment on your box you should be able to write simply "(local)" in the server name and it should connect. If you specified an "instance name" when you installed you can also use that. Are you using windows or sql-server authentication? In case of sql-server you need to provide a valid username and password also. "SA" is the built in system administrator (sql server auth) and you probably created a password for that account during setup.

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

associates
Starting Member

31 Posts

Posted - 2006-07-31 : 03:53:41

Hi Lumbago,

Thank you for your reply.

I got the error when trying to connect to local which is itself and used the windows authentication.

Thank you

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-07-31 : 04:01:08

But are you still having problems?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources