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 |
|
simplygrandmaster
Starting Member
1 Post |
 Posted - 2010-05-15 : 05:27:38
|
| Dear ExpertsI'm not really good at SQL Server administration, though I'm trying to build up a website with SQL 2008 Express as the backend.The SQL Server Express is installed on my computer. My connection string was earlier working using both Windows and SQL server authentication... and in fact even now, my application connects successfully to the backend.The problem: I'm on Windows XP Pro, where I was using the default administrator account. After I created a new Windows user, I'm also able to connect using Windows Authentication. But somehow, it connects toSERVER\SQL Express(SQL Server 10.0.1600 - Server\usernameinstead ofSERVER\SQL Express(SQL Server 9.0.1399 - Server\usernameand my database, the one which I'm building is in the version SERVER\SQL Express(SQL Server 9.0.1399 - Server\usernameSo how can I instruct SQL Server Management Studio to allow me to connect to the version 9, so that I can run "use <mydatabase>"?Any advice would be much appreciated, I really dont know how to do this.ThanksSG |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-05-17 : 09:36:44
|
| SQL Server 9.0 is SQL2005, not SQL 2008. That may be part of the problem. Check out this site. It may provide some additional info for you.http://tinyurl.com/2ezsgj7Terry-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby |
 |
|
|
|
|
|
unable to connect to SQL Express using Win Authent