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
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Troubles getting started with SQL 2005 Express

Author  Topic 

Afroblanca
Starting Member

9 Posts

Posted - 2005-12-05 : 10:24:51
So, I downloaded and installed SQL Server 2005 Express, and I just can't figure out how to get it to do anything.

I'm accustomed to SQL Server 2000, and I don't see anything familiar.

Where's Query Analyzer? Where's Enterprise Manager? All I see is this "Configuration Manager" stuff, which doesn't seem particularly useful.

How am I supposed to use this software? I feel like they could have tried a little harder on this one.

karuna
Aged Yak Warrior

582 Posts

Posted - 2005-12-05 : 22:53:22
To manage SQL Server Express 2005, you also need to install Sql Server Management Studio Express which can be downloaded here
http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

Thanks


Karunakaran
Go to Top of Page

ra_pascual
Starting Member

1 Post

Posted - 2005-12-08 : 18:35:19
download also the management studio express. This looks like the enterprise manager but i notice its more like the access when i created table and its column.

i cannot however connect to my database, always with an error in my asp ... not a trusted connection..
Go to Top of Page

karuna
Aged Yak Warrior

582 Posts

Posted - 2005-12-09 : 08:29:08
my guess is that sql is using Windows Authentication and you are trying to connect using sql login.
In the management studio, select the db server-> properties and change the settings to accept both sql and windows or in your asp use windows authentication.

Thanks


Karunakaran
Go to Top of Page
   

- Advertisement -