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)
 How to connect to my sql server express

Author  Topic 

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2006-02-20 : 13:46:24
1, I have installed VWD express,sql server 2005 express.I also install management studio and adventureswork db.In the management studio I can able to connect and view adventurework db.
But I can't manage to make a connection string to my db server when connecting to management studio server name is "KAMRANSHAHID\SQLEXPRESS".I wants a connection string with respect to this server.
2,Is there new database for pubs and northwind for sql server 2005.Or they are of old sql server 2000.
I have installed sample databases but can't find script for pubs and northwind nor dit it install automatically.
I wan't to use forums.asp.net asp.net tutorial's sample.
What Can I do.

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2006-02-20 : 15:30:48
#1 Try '.\SQLEXPRESS'

#2 No - AdventureWorks and AdventureWorksDW replaced pubs and northwind.


Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine + SQL Express
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
Go to Top of Page

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2006-02-20 : 23:33:27
It will be very nice if you post full connection string.
Thanks
Go to Top of Page

kamii47
Constraint Violating Yak Guru

353 Posts

Posted - 2006-02-21 : 00:01:19
Ok I have got it.Thanks buddy.
Go to Top of Page
   

- Advertisement -