various errors connecting - possible permissions problem

[jhardman]

I keep getting connection errors that appear to me to relate to user permissions.

I tried connecting with DSN from both a classic ASP page using VBScript, and from a .NET web service using C#, both give an error "Invalid object name 'xxx'" where 'xxx' is the name of the table I specify in my query. Since I'm just using a DSN, my connection string is fairly simple:

"DSN=myDSN;Uid=myUID;pwd=myPWD"

If I alter the UID or PWD to someting outlandish and definitely wrong, I get the same message. However, if I change the DSN, I get a different error (Data source name not found and no default driver specified). This suggests to me that my user is not logging in, but my DSN itself is correct. Is there any good troubleshooting guide (or do any of you have a good protocol) for setting user permissions?

But that might not be the whole problem, I was installing a program that uses a SQL db, and installation threw this error

[dbnetlib][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

support.microso ft.com seems to say this usually only comes up with networked computers, but I'm running SQL Server locally. Any suggestions?

I'm using MS SQL Server 2005 Express, and management Studio Express.

Jared

[ck9663]

Try using Windows authentication and not SQL Server Authentication.

-- CK

[jhardman]

Try using Windows authentication and not SQL Server Authentication.

-- CK

arghh. That's not what I wanted to hear. Let me think if I can make that work, meanwhile if you can think of any other suggestions...

Jared