SQL (Express) database login fails from web service


B

Bill Cohagan

I have a WebServices project that access a database (in the App_Data folder).
I'm trying to move the project/solution to a new replacement development
machine and am having problems with the database login failing. I'm using a
workgroup, not AD.

I moved the project (including database) from old to new machine using file
copy. I've reset the database owner to the appropriate new machine user
account corresponding to the one on the old machine. When I run the app
however I get a login failure on the database, but it does appear to be using
the login associated with the dbo.

One other complication is that the old machine was XP Pro while the new
machine is Windows 7 RC1 (build 7100).

Any suggestions/ideas?

Thanks in advance,
Bill
 
Ad

Advertisements

B

Bill Cohagan

Well, it was a connection string problem. The login failure was a red herring
as the login itself was correct; however SQL Server (rightfully) doesn't give
away much when there's any kind of login problem. The log entries weren't
much help either as they just gave a status code 16 with the error.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top