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.
| Author |
Topic |
|
Ree
Starting Member
3 Posts |
 Posted - 2006-05-03 : 10:01:31
|
| Hello,SQL Express was silently installed together with Visual Studio 2005 on my XP Pro SP2 machine. I was never promted to provide a password for SQL Express... How do I know the credentials I need to use to log into SQL Express? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-03 : 10:22:43
|
| It's probably installed with trusted security only.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-05-03 : 11:27:19
|
| Ree,nr's right. It automatically installs using NT Authentication.Just open the Database Explorer in VS Express and connect to the database.Ken |
|
|
|
Ree
Starting Member
3 Posts |
Posted - 2006-05-03 : 11:51:10
|
| Hm... I do not use VS Express, I installed VS 2005 Pro.Yes, I can connect via VS. But what if I want to use Web Data Administrator (Web GUI for SQL Server management)? You must provide username + password there to login. I have tried my Windows credentials (username + blank password) without any luck. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-03 : 12:54:54
|
| http://msdn2.microsoft.com/en-us/library/ms143705.aspxIf you select Windows Authentication, Setup creates an sa account that is disabled by default. To use Mixed Mode Authentication and activate the sa account after Setup completes, see the How to: Change Server Authentication Mode and ALTER LOGIN (Transact-SQL) topics in SQL Server 2005 Books Online.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Ree
Starting Member
3 Posts |
Posted - 2006-05-03 : 13:28:15
|
| Thank you a lot!I have been searching for something this simple the whole day today. It now works just fine. Thanks again. |
|
|
|
|
|
|
What's my login?