July 1, 2011 at 9:52 am
I'm trying to write a simple app, using Visual Studio 2010, to test accessing a SQL Server 2008 Express database. I've tried using Windows Authentication, but that fails, all of the time. I had created 2 SQL Logins and users for my SQL Express database, and assigned to both of them the database that I want to use, as their default database. Saved the changes.
As luck would have it, I've been wrapped up with end-of-fiscal-year activities totally unrelated to this work. Have been for weeks. But today I thought I'd give it another try. I got into SSMS and tried to open the SQL 2008 Express database, using Windows Authentication. But now I can't even do that! I get this error:
"Cannot connect to MYPC\SQLEXPRESS
Cannot open user default database. Login failed.
Login failed for user 'MYDOMAIN\rod'. (Microsoft SQL Server, Error: 4064)"
Great scott, this is how I created the thing in the first place, and man I put in a heck of a lot of time designing that SQL 2008 Express database!!! Almost 100 tables, views and stored procedures, and now I can't even open it using the very same authentication method that I used to create it?! What's going on here???
If I choose one of the 2 SQL logins/users that I created, I get much the same error message:
"Cannot connect to MYPC\SQLEXPRESS
Cannot open user default database. Login failed.
Login failed for user 'intake'. (Microsoft SQL Server, Error: 4064)"
("intake" was one of the SQL logins I created.)
So, have I lost about 2 weeks of work setting up the database? It looks like I can't get into SQLEXPRESS at all on my PC anymore. Why is that? Frankly, I'm extremely frustrated with this thing. THis is meant to replace a mission critical application, and if I cannot open it is SSMS, there's no way I'll ever be able to open it in any app I write. I need help, please.
I'm working on a Windows 7 Ultimate machine, 32-bit. I've got SQL Server 2008 R2 Developer Edition installed, and that's the SQL Server Management Studio version that I use to access everything. I installed SQL Server 2008 Express onto my machine, and that's what I'm trying to use as a local data store, which I'd like to use for installing on user machines. (I didn't install SQL Server 2008 Expression R2, for no reason other than I just didn't, but I was thinking it wouldn't matter.)
Kindest Regards, Rod Connect with me on LinkedIn.
July 1, 2011 at 10:19 am
Have you verified that the service for that instance is running?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply