September 13, 2005 at 6:49 am
Scenario-
We have two machines
1-SQL Server 2000 over windows 2000 server installed.
2-Web server over windows 2000 server with .Net Framework 1.1 installed.
we need to establish the sql server connection between these two machines.when client runs home page the error comes on the page is "System.Security.SecurityException: Requested registry access is not allowed.
"
please send us the solution to solve the issue.
September 14, 2005 at 10:31 am
Before posting at least try 'googling' for an answer first ...
I googled on your error string:
"System.Security.SecurityException: Requested registry access is not allowed."
And received this link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;329291
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 14, 2005 at 11:24 am
September 14, 2005 at 12:34 pm
What type of connection are you attempting ? Has it worked before ? Can you use the ODBC administrator on the IIS server to connect successfully to the database server ? Maybe posting your connection string(s) too ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 14, 2005 at 12:54 pm
To connect with a standard SQL login, you could try something like the following (of course, change the user id, password, server, and database):
Dim strLoginID
Dim strPassword
Dim strConnect
Dim objConn
strLoginID = "SQLID"
strPassword = "password"
strConnect = "Driver={SQL Server};Server=SERVERNAME;Database=DBNAME;uid=" + strLoginID + ";pwd=" + strPassword
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnect
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply