Re: asp.net 2.0 connectoin string (hopefully last question)

Tech-Archive recommends: Fix windows errors by optimizing your registry



Here are some options on what it could potentially be:

1. Make sure that your username / login is attached to the
database/catalog and make sure that the user has the valid permissions,
if you want to make 100% sure that this is the issue, give the user the
dbowner role. if that works, go back and give the user the appropiate
roles/permissions.

2. Another option could be that your database is not setup to use SQL
server authentication? Just look up the instance's properties and
change the security option to allow SQL Server logins.

3. You database server's name could require a different name... if your
server's name is "MYSQLSERVER", you may need to use ".\MYSQLSERVER"
with the ".\" included.

I hope atleast one of those suggestions helps out... Sorry if I didn't
help.

Pz

Jose

.



Relevant Pages

  • RE: Receiving JDBC error when executing program - Login failed for user sa
    ... says we're using 'sa' so I would think that's the username being passed in. ... | I am receiving the following error when attempting to run my database ... I tried to login the 'sa' account ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Dynamic SQL
    ... Don't need to login to the database. ... OF course entering username N00bHax0r') will cause an error. ... // is the Validators good for this ????? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)