I completely uninstalled 2000 and did a clean install of 2005. I restored m
y
database and users and all seems fine. I am set up with mixed authenticatio
n
(windows and sql server). My username is in security/logins as well as in
database/security/users with connect and select permissions.
I am getting the following error when trying to submit my asp page:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database "dbName" requested by the login. The login failed.
/AddressSearch/SearchResults.asp, line 40Hi
This sounds like you have orphaned users
121120120" target="_blank">http://support.microsoft.com/defaul...r />
121120120
John
"SharinDenver" wrote:
> I completely uninstalled 2000 and did a clean install of 2005. I restored
my
> database and users and all seems fine. I am set up with mixed authenticat
ion
> (windows and sql server). My username is in security/logins as well as in
> database/security/users with connect and select permissions.
> I am getting the following error when trying to submit my asp page:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Cannot open database "dbName" requested by the login. The login failed.
> /AddressSearch/SearchResults.asp, line 40
>|||You rock! Thank you! Those articles worked perfectly.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This sounds like you have orphaned users
> 20121120120" target="_blank">http://support.microsoft.com/defaul.../>
20121120120
> John
> "SharinDenver" wrote:
>
Showing posts with label clean. Show all posts
Showing posts with label clean. Show all posts
Friday, March 23, 2012
new SQL Server 2005 install giving login error... HELP!
I completely uninstalled 2000 and did a clean install of 2005. I restored my
database and users and all seems fine. I am set up with mixed authentication
(windows and sql server). My username is in security/logins as well as in
database/security/users with connect and select permissions.
I am getting the following error when trying to submit my asp page:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database "dbName" requested by the login. The login failed.
/AddressSearch/SearchResults.asp, line 40
Hi
This sounds like you have orphaned users
http://support.microsoft.com/default...21120121120120
John
"SharinDenver" wrote:
> I completely uninstalled 2000 and did a clean install of 2005. I restored my
> database and users and all seems fine. I am set up with mixed authentication
> (windows and sql server). My username is in security/logins as well as in
> database/security/users with connect and select permissions.
> I am getting the following error when trying to submit my asp page:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Cannot open database "dbName" requested by the login. The login failed.
> /AddressSearch/SearchResults.asp, line 40
>
|||You rock! Thank you! Those articles worked perfectly.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This sounds like you have orphaned users
> http://support.microsoft.com/default...21120121120120
> John
> "SharinDenver" wrote:
database and users and all seems fine. I am set up with mixed authentication
(windows and sql server). My username is in security/logins as well as in
database/security/users with connect and select permissions.
I am getting the following error when trying to submit my asp page:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database "dbName" requested by the login. The login failed.
/AddressSearch/SearchResults.asp, line 40
Hi
This sounds like you have orphaned users
http://support.microsoft.com/default...21120121120120
John
"SharinDenver" wrote:
> I completely uninstalled 2000 and did a clean install of 2005. I restored my
> database and users and all seems fine. I am set up with mixed authentication
> (windows and sql server). My username is in security/logins as well as in
> database/security/users with connect and select permissions.
> I am getting the following error when trying to submit my asp page:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Cannot open database "dbName" requested by the login. The login failed.
> /AddressSearch/SearchResults.asp, line 40
>
|||You rock! Thank you! Those articles worked perfectly.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> This sounds like you have orphaned users
> http://support.microsoft.com/default...21120121120120
> John
> "SharinDenver" wrote:
new SQL Server 2005 install giving login error... HELP!
I completely uninstalled 2000 and did a clean install of 2005. I restored my
database and users and all seems fine. I am set up with mixed authentication
(windows and sql server). My username is in security/logins as well as in
database/security/users with connect and select permissions.
I am getting the following error when trying to submit my asp page:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database "dbName" requested by the login. The login failed.
/AddressSearch/SearchResults.asp, line 40Hi
This sounds like you have orphaned users
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#XSLTH3182121121120121120120
John
"SharinDenver" wrote:
> I completely uninstalled 2000 and did a clean install of 2005. I restored my
> database and users and all seems fine. I am set up with mixed authentication
> (windows and sql server). My username is in security/logins as well as in
> database/security/users with connect and select permissions.
> I am getting the following error when trying to submit my asp page:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Cannot open database "dbName" requested by the login. The login failed.
> /AddressSearch/SearchResults.asp, line 40
>|||You rock! Thank you! Those articles worked perfectly.
"John Bell" wrote:
> Hi
> This sounds like you have orphaned users
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#XSLTH3182121121120121120120
> John
> "SharinDenver" wrote:
> > I completely uninstalled 2000 and did a clean install of 2005. I restored my
> > database and users and all seems fine. I am set up with mixed authentication
> > (windows and sql server). My username is in security/logins as well as in
> > database/security/users with connect and select permissions.
> >
> > I am getting the following error when trying to submit my asp page:
> >
> >
> > Microsoft OLE DB Provider for SQL Server error '80004005'
> >
> > Cannot open database "dbName" requested by the login. The login failed.
> >
> > /AddressSearch/SearchResults.asp, line 40
> >
database and users and all seems fine. I am set up with mixed authentication
(windows and sql server). My username is in security/logins as well as in
database/security/users with connect and select permissions.
I am getting the following error when trying to submit my asp page:
Microsoft OLE DB Provider for SQL Server error '80004005'
Cannot open database "dbName" requested by the login. The login failed.
/AddressSearch/SearchResults.asp, line 40Hi
This sounds like you have orphaned users
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#XSLTH3182121121120121120120
John
"SharinDenver" wrote:
> I completely uninstalled 2000 and did a clean install of 2005. I restored my
> database and users and all seems fine. I am set up with mixed authentication
> (windows and sql server). My username is in security/logins as well as in
> database/security/users with connect and select permissions.
> I am getting the following error when trying to submit my asp page:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> Cannot open database "dbName" requested by the login. The login failed.
> /AddressSearch/SearchResults.asp, line 40
>|||You rock! Thank you! Those articles worked perfectly.
"John Bell" wrote:
> Hi
> This sounds like you have orphaned users
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#XSLTH3182121121120121120120
> John
> "SharinDenver" wrote:
> > I completely uninstalled 2000 and did a clean install of 2005. I restored my
> > database and users and all seems fine. I am set up with mixed authentication
> > (windows and sql server). My username is in security/logins as well as in
> > database/security/users with connect and select permissions.
> >
> > I am getting the following error when trying to submit my asp page:
> >
> >
> > Microsoft OLE DB Provider for SQL Server error '80004005'
> >
> > Cannot open database "dbName" requested by the login. The login failed.
> >
> > /AddressSearch/SearchResults.asp, line 40
> >
Subscribe to:
Posts (Atom)