June 8, 2004 at 5:26 pm
I am having a problem connecting from my asp page to my local sql server database. I have done this before wothout hassles however I just can't seem to make this work.
The asp script is ...........
<%
Dim ob_Conn
Set ob_Conn = Server.CreateObject("ADODB.Connection")
ob_Conn.Provider = "sqloledb"
Dim Provider
Provider = "Server=ITSD-NXBZKACII0\TRG;Database=TRG;UID=jules;PWD=jules;"
ob_Conn.Open Provider
%>
The error message i get from the browser is..
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'jules'. Reason: Not associated with a trusted SQL Server connection.
/TRG/Connect.asp, line 19
User 'jules' is set up as system administrator with public & db_owner access.
Can anybody see an obvious ,mistake I am making?
Glenn
June 10, 2004 at 4:52 am
to give permision to a user on an object in your Database ..
you have to do 2 things:
1- make a login ... this is done from EM under security .. under logins .. then right click .. new login
it is recommended to make SQL Server authentication .. by putting a password for that user
and so you have to write down this name and its password in your connection string
2- then in EM .. go to your DB .. and under user .. right click .. New db user
in login name .. choose the login you write before and click ok
the double click on this user again .. and press permissions .. and put (~/) true sign to the permissions you
want to give to that user on your tables, views, Stored procedure , .. etc
I hope this help u
Alamir Mohamed
Alamir_mohamed@yahoo.com
June 10, 2004 at 7:44 am
Is your server security (in EM, right click on Server, select server properties, then the security tab) configured for mixed mode? Maybe it's setup for "Windows Only" and 'jules' is a SQL login id, not a Windows login id.
If so, switch to mixed mode, or as Alamir mentioned, create a new Windows login (select Windows Authentication) that is mapped to your Windows account.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply