SqlConnection Access Is Denied Exception With SQL Server 2005
Feb 21, 2006
Hi,
I have a SqlConnection object with connection string, "Data Source=server1;Initial Catalog=CDCollection;User Id=joe;Password=11111."
For User ID, I created a new user "joe" in the Management Studio.
I tried to use this user, but sqlconnection threw an exception stating access was denied.
I noticed that SQL Server 2005 has user accounts that you can create for the server and for the database, but I am confused by this. How can a create a non-sa user account that I can give to the SQLConnection object that will work? Do I need to create a user for the server and the same user for the database CDCollection? I am not all familiar with SQL Server administration.
Any help or leads would be appreciated.
View 3 Replies
ADVERTISEMENT
Nov 22, 2005
hI all,
I have sql server 2000 installed on one machine running
windows server 2003 and using VS 2003 to code and run IIS 5.0 on
another machine running windows XP.
I'm getting the error: sql exception: SQL Server does not exist or
access denied. But i tried using osql to connect to the sql
server from the XP machine and it works fine!
Can someone pls help me and tell me why i get this error for my webapp
but i can connect to the sql server with osql? Thanks in Advance
View 1 Replies
View Related
Apr 24, 2007
I am running SQL Express with Reporting Services 2005 SP2.
Installed both on with the NT-AuthorityNetwork Service
I uploaded a report and I can execute it in the Report Manager.
What I want to do is execute the report via Webservice and stream the result as PDF.
Code SnippetReporting.ReportExecutionService svc = new Reporting.ReportExecutionService();
svc.Credentials = System.Net.CredentialCache.DefaultCredentials;
svc.LoadReport(report, historyID);
svc.SetExecutionParameters(parameters, "en-us");
byte[] results = svc.Render(format,deviceInfor,out fileNameExtension,out mimeType,out encoding,out warnings,out streams);
this.Response.Clear();
this.Response.ContentType = "application/pdf";
this.Response.AddHeader("Content-disposition", "attachment; filename=Report.pdf");
this.Response.BinaryWrite(results);
this.Response.End();
this is my code in the asp.net page
and I get following exception
System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
Source Error:
Line 206: [return: System.Xml.Serialization.XmlElementAttribute("executionInfo")]
Line 207: public ExecutionInfo LoadReport(string Report, string HistoryID) {
Line 208: object[] results = this.Invoke("LoadReport", new object[] {
Line 209: Report,
Line 210: HistoryID});
Source File: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eporttest8a8d2a7956046022App_WebReferences.x8k9hsoj.0.cs Line: 208
Stack Trace:
[SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'NT-AUTORITÄTNETZWERKDIENST' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
at Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, Int32& pageCount, Boolean& hasDocMap, PageSettings& reportPageSettings)
at Microsoft.ReportingServices.Library.CreateNewSessionAction.Save()
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +533462
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +204
Reporting.ReportExecutionService.LoadReport(String Report, String HistoryID) in c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eporttest8a8d2a7956046022App_WebReferences.x8k9hsoj.0.cs:208
_Default.RenderReport(String client_short, String gobj_long, String event_date, String event_time) in c:WebsitesReportTestDefault.aspx.cs:68
_Default.Button1_Click(Object sender, EventArgs e) in c:WebsitesReportTestDefault.aspx.cs:22
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Looks like I need some additional adjustment on the authentication. But I do not know where and how.
I try to change the webservice identity but after changing the user identity of the application pool in iis ( I think this is the only way to change webservice identity) I got the error message service unavailable in IIS. With this I also couldn't start the webfront end any more. Switching back to NT-AuthorityNetwork Serive the web front end worked again.
I tryed to add
Code Snippet<identity impersonate="true" />
to the web config and I get the same Error on the webserver account...
It would be great if someone could help me to adjust the settings...
View 1 Replies
View Related
Oct 17, 2005
I am trying to access a SQL 2005 database on a seperate machine, using a COM+ proxy which is installed on my machine. I keep getting this error:
View 5 Replies
View Related
Mar 4, 2008
My SqlConnection is causing an error "sqlConn.ServerVersion threw an exception of type System.InvalidOperationException". Everything I have read seems to suggest that there is a problem with my SQLConnection parameters but as you can see from the commeted code below I have tried three different servers with four different configurations. I am out of ideas on what is causing the error.
Thanks - Amy
Here is a section of my code:
String sqlStmt = "Select [UserName], [Password], [Last], [First] from Contacts Where Login=@Uid AND Password=@Pwd";
SqlConnection sqlConn = new SqlConnection("Data Source=localhost;Initial Catalog=test;Integrated Security=SSPI;");//SqlConnection sqlConn = new SqlConnection("Data Source=pe2800;Initial Catalog=test;Integrated Security=SSPI;");//SqlConnection sqlConn = new SqlConnection("Data Source=HorizonDC02;Initial Catalog=test;Integrated Security=SSPI;");//SqlConnection sqlConn = new SqlConnection("Data Source=HorizonDC02;Initial Catalog=test;User ID=username;Password=password;");
SqlCommand sqlCmd = new SqlCommand(sqlStmt, sqlConn);sqlCmd.Parameters.Add("@Uid", SqlDbType.VarChar, 30).Value = uid;sqlCmd.Parameters.Add("@Pwd", SqlDbType.VarChar, 30).Value = pwd;sqlCmd.Connection.Open();
View 2 Replies
View Related
Jun 10, 2015
I have recently upgraded to SQL2014 on Win2012. The Access front end program works fine.
But, previously created Excel reports with built in MS Queries now fail with the above error for users with MS 2013. The queries still work for users still using MS 2007.Â
I also cannot create any new queries and get the same error message. If I log on as myself on the domain to another PC with 2007 installed it works fine, so I don't think it is anything to do with AD groups or permissions.
View 6 Replies
View Related
Apr 22, 2015
When i am trying to start our hospital software based on SQL server 2000, it shows Following Error.Search Condition is not valid, (DBNETLIB) Connection Open (connect()).  SQL server does not exist or excess denied. Due to Fetch data.I run our software in Windows 8.1, while it smothly runs in previous version of Windows XP and 7.
View 2 Replies
View Related
Nov 15, 2006
Hi:
I am getting access denied error "cannot connect to server" while trying to connect Integration Services. I am trying to connect from my laptop to the SQLSERVER database server.
I followed the document "Connecting to a Remove Intergration Services Server" , doc id: aa337083.
But I can connect to IS if I log remotely to the server.
Any thoughts on this ?
Thanks
-Rajesh
I am getting following errors.
===================================
Cannot connect to cvsslmdd1-vm.
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Program Location:
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
===================================
Connect to SSIS Service on machine "cvsslmdd1-vm" failed:
Access is denied.
.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
===================================
Connect to SSIS Service on machine "cvsslmdd1-vm" failed:
Access is denied.
.
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)
View 7 Replies
View Related
Jan 3, 2007
I am using a standard installation of SQL 2005 Express installed with Visual C# Express. I have tried several connection strings, have tried connecting different databases, all of which end up giving me access denied for user <machineName>Greg (Greg is the local admin account for this PC. I found this guideline for connectivity questions (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1), and have gone through it all, posting the answers to questions here. One thing that may be different about this machine is that it is a tablet PC (WinXP Tablet edition) and I am running VMWare Server. I also tried loading it on a WinXP Pro workstation with no VMWare, and have gotten the same results. Any help will be greatly appreciated.
My connection string:
@"Server=(local);Integrated Security=SSPI;Database=Database1");
Client error message:
Cannot open database "Database1" requested by the login. The login failed. Login failed for user 'GREGBORGGreg'.
Client is local to the SQL 2005 Express - this is an application running on a local PC.
I am able to ping -a GREGBORG (as well as localhost)
I am able to telnet to port 1433 of my local machine, although Ctrl+[ does not give me an SQL prompt
I am using ADO.NET 2.0 and Visual C# 2005 Express
I have enabled Shared memory, named pipes and TCP/IP.
I have no alias' configured, and am not requiring encryption.
=========================
I am using SQL 2005 Express loaded on Windows XP tablet edition.
The SQL browser is not enabled, and it says that it has no enabled devices associated with it.
SQL Server is running under the Network System account
I have tried running it firewalled and not firewalled
I am running Clamwin anti-virus
From the ERRORLOG:
2007-01-03 12:29:56.19 Logon Error: 18456, Severity: 14, State: 16.
2007-01-03 12:29:56.19 Logon Login failed for user 'GREGBORGGreg'. [CLIENT: 10.101.1.200]
From the command prompt I get:
C:Documents and SettingsGreg>osql -E -S (local)sqlexpress
1> use Database1
2> go
Msg 911, Level 16, State 1, Server GREGBORGSQLEXPRESS, Line 1
Could not locate entry in sysdatabases for database 'Database1'. No entry found
with that name. Make sure that the name is entered correctly.
When I try to attach Database1 in my 'My Documents' folder, it says that access is denied to the file.
I added a user via SQL Management Studio Express and then received the error:
C:Documents and SettingsGreg>osql -S gregborgsqlexpress -U Greg -P ********
1> sp_attach_db "Database1", "C:documents and SettingsGregMy DocumentsVisual
Studio 2005Projects est_SQL est_SQLDatabase1.mdf"
2> go
Msg 5133, Level 16, State 1, Server GREGBORGSQLEXPRESS, Line 1
Directory lookup for the file "C:documents and SettingsGregMy
DocumentsVisual Studio 2005Projects est_SQL est_SQLDatabase1.mdf" failed
with the operating system error 5(Access is denied.).
1> use northwind
2> go
Msg 945, Level 14, State 2, Server GREGBORGSQLEXPRESS, Line 1
Database 'Northwind' cannot be opened due to inaccessible files or insufficient
memory or disk space. See the SQL Server errorlog for details.
In the ERRORLOG I have:
2007-01-03 12:38:27.25 spid51 Error: 5173, Severity: 16, State: 1.
2007-01-03 12:38:27.25 spid51 One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.
2007-01-03 13:07:16.82 spid51 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2007-01-03 13:09:24.68 Logon Error: 18456, Severity: 14, State: 8.
2007-01-03 13:09:24.68 Logon Login failed for user 'Greg'. [CLIENT: <local machine>]
2007-01-03 13:09:27.43 Logon Error: 18456, Severity: 14, State: 8.
2007-01-03 13:09:27.43 Logon Login failed for user 'Greg'. [CLIENT: <local machine>]
Again, thank you for any help. I think I may have been staring at this too long to be productive any more...
--Greg
View 3 Replies
View Related
Oct 30, 2007
I cannot get SQL Server 2005 Express installed on a 2003 Small Business Server. I am logged in as an admin.
The error:
Code Block
Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied.
I have uninstalled all instances of SQL Server. Rebooted server and tried again, but get same error.
Any ideas?
View 1 Replies
View Related
Oct 18, 2007
Hi all,
In the Object Explorer of my SQL Server 2005 Management Studio Express, I do not have €˜Northwind€™ Database installed yet. I executed the following source code (that was copied from a book) in my VB 2005 Express:
/////////////////////----Form9.vb----//////////////////////////
Imports System.Data.SqlClient
Imports System.Data
Public Class Form9
Dim cnn1 As New SqlConnection
Private Sub Form5_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Compute top-level project folder and use it as a prefix for
'the primary data file
Dim int1 As Integer = InStr(My.Application.Info.DirectoryPath, "bin")
Dim strPath As String = Microsoft.VisualBasic.Left(My.Application.Info.DirectoryPath, int1 - 1)
Dim pdbfph As String = strPath & "northwnd.mdf"
Dim cst As String = "Data Source=.sqlexpress;" & _
"Integrated Security=SSPI;" & _
"AttachDBFileName=" & pdbfph
cnn1.ConnectionString = cst
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'Create a command to create a table
Dim cmd1 As New SqlCommand
cmd1.CommandText = "CREATE TABLE FromExcel (" & _
"FirstName nvarchar(15), " & _
"LastName nvarchar(20), " & _
"PersonID int Not Null)"
cmd1.Connection = cnn1
'Invoke the command
Try
cnn1.Open()
cmd1.ExecuteNonQuery()
MessageBox.Show("Command succeeded.", "Outcome", _
MessageBoxButtons.OK, MessageBoxIcon.Information)
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cnn1.Close()
End Try
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
'Create a command to drop a table
Dim cmd1 As New SqlCommand
cmd1.CommandText = "DROP TABLE FromExcel"
cmd1.Connection = cnn1
'Invoke the command
Try
cnn1.Open()
cmd1.ExecuteNonQuery()
MessageBox.Show("Command succeeded.", "Outcome", _
MessageBoxButtons.OK, MessageBoxIcon.Information)
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cnn1.Close()
End Try
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
'Declare FromExcel Data Table and RowForExcel DataRow
Dim FromExcel As New DataTable
Dim RowForExcel As DataRow
FromExcel.Columns.Add("FirstName", GetType(SqlTypes.SqlString))
FromExcel.Columns.Add("LastName", GetType(SqlTypes.SqlString))
FromExcel.Columns.Add("PersonID", GetType(SqlTypes.SqlInt32))
'Create TextFieldParser for CSV file from spreadsheet
Dim crd1 As Microsoft.VisualBasic.FileIO.TextFieldParser
Dim strPath As String = _
Microsoft.VisualBasic.Left( _
My.Application.Info.DirectoryPath, _
InStr(My.Application.Info.DirectoryPath, "bin") - 1)
crd1 = My.Computer.FileSystem.OpenTextFieldParser _
(My.Computer.FileSystem.CombinePath(strPath, "Book1.csv"))
crd1.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited
crd1.Delimiters = New String() {","}
'Loop through rows of CSV file and populate
'RowForExcel DataRow for adding to FromExcel
'Rows collection
Dim currentRow As String()
Do Until crd1.EndOfData
Try
currentRow = crd1.ReadFields()
Dim currentField As String
Dim int1 As Integer = 1
RowForExcel = FromExcel.NewRow
For Each currentField In currentRow
Select Case int1
Case 1
RowForExcel("FirstName") = currentField
Case 2
RowForExcel("LastName") = currentField
Case 3
RowForExcel("PersonID") = CInt(currentField)
End Select
int1 += 1
Next
int1 = 1
FromExcel.Rows.Add(RowForExcel)
RowForExcel = FromExcel.NewRow
Catch ex As Microsoft.VisualBasic.FileIO.MalformedLineException
MsgBox("Line " & ex.Message & _
"is not valid and will be skipped.")
End Try
Loop
Try
cnn1.Open()
Using sqc1 As SqlBulkCopy = New SqlBulkCopy(cnn1)
sqc1.DestinationTableName = "dbo.FromExcel"
sqc1.WriteToServer(FromExcel)
End Using
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
cnn1.Close()
End Try
'Read the FromExcel table and display results in
'a message box
Dim strQuery As String = "SELECT * " & _
"FROM dbo.FromExcel "
Dim str1 As String = ""
Dim cmd1 As New SqlCommand(strQuery, cnn1)
cnn1.Open()
Dim rdr1 As SqlDataReader
rdr1 = cmd1.ExecuteReader()
Try
While rdr1.Read()
str1 += rdr1.GetString(0) & ", " & _
rdr1.GetString(1) & ", " & _
rdr1.GetSqlInt32(2).ToString & ControlChars.CrLf
End While
Finally
rdr1.Close()
cnn1.Close()
End Try
MessageBox.Show(str1, "FromExcel")
End Sub
End Class
///////////////////////////////////////////////////////////////////////
This is Part 1 (The length of input exceeds 50000 characters). Part 2 will be posted in this site shortly.
View 4 Replies
View Related
Aug 12, 2007
All,
I have installed sqlserver 2005 using the standard msdn universal installation discs on my laptop running vista business.
The mssqlserver service will not start automatically as the setup configures it
and I cannot start the service manually because I get the 'Access Denied' error message
I am logged on the the computer with adminstration privileges
Thank for all help received in advance,
Dave.....
View 2 Replies
View Related
Apr 3, 2005
Hi
Recently I install XP SP2 (wish I wouldn’t!) , now I cant use MS SQL databases , this is the error :
SQL Server does not exist or access denied
I add to ports 1433 and 1434 to windows firewall , as this article said :
http://www.docs.com/HelpFiles/WindowsXPServicePack2Fix.htm
but I doesn’t work
Do any one know how can I fix it ?
Tanks,
View 8 Replies
View Related
Sep 5, 2007
I have been encountering a problem using a CLR Assembly in SQL server. The Assembly is one provided by Microsoft for an example on using Exchange web services with SQL server.
http://www.microsoft.com/downloads/details.aspx?FamilyId=D6924897-7B62-46FD-874E-24FB0FBA2159&displaylang=en#Requirements
Essentially what this package is, is a set of c# classes that access the Exchange 2007 Web Services via a set of user defined functions and views in MS SQL Server 2005.
We have not modified the code except to configure for our host environment.
We are able to register the assembly using the setup.sql file included. But when we try to access any of the views or use the functions we get the following error:
Msg 10314, Level 16, State 11, Line 10
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65551. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:
System.IO.FileLoadException: Could not load file or assembly 'exchangeudfs, Version=0.0.0.0, Culture=neutral, PublicKeyToken=777b97dde00f3dbe' or one of its dependencies. The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)
System.IO.FileLoadException:
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
We have 3 testing environments. 2 Windows 2003 servers called test and test2. Also a single Windows 2000 server called test3. Test and test2 have a full suite installed on them, web server, exchange 2007, sql server 2005, they are also domain controllers for their own domains.
We get the above error on test and test2 but it runs fine on test3. Test and test2 represent what our production environment is like. Test3 was just part of our troubleshooting process.
We have tried a lot to make this work. Here are some details on the things we have tried.
The database is set up to allow CLR Assemblies. This is part of the setup.sql.
The assembly's permission is set to external_access.
We have gone all the way to setting the file permissions on the dll to full control to the Everyone group.
We have tried different accounts to run the SQL Service. We've tried the system account, the local admin account and a seperate user account.
The database we are using is a fresh brand new database. Therefore it does not fit into the bug reported in this article:
http://support.microsoft.com/kb/918040
I am really at a loss to where to go from here. Any ideas on why this 'out of the box' solution is causing us so many headaches would be appriciated.
Thanks,
Tim
View 4 Replies
View Related
Dec 13, 2007
My web project (ASP.NET 2.0 / C#) runs against sql server 2000 and uses the System.Data.SqlClient.using System.Data.SqlClient;
I use System.Data.SqlClient.SqlConnection and System.Data.SqlClient.SqlCommand to make the connections to the database and do selects and updates. Is it correct to continue to use these against SQL Server 2005? I ask because I made a connection string (outside of .Net) for SqlServer 2005 using the SQL native provider and it had the following - Provider=SQLNCLI.1 and any connection strings I had made (also outside of ASP.NET) fro SQL Server all used Provider=SQLOLEDB.1. This is why I wondered if there is a different SqlClient in .Net 2.0 for SQL Server 2005?
Cheers
Al
View 1 Replies
View Related
Oct 6, 2006
I have recently deployed a web app that I have been developing onto the production server (Windows 2003 SP1 + an SQL Server 2000 SP4 cluster). The web app uses both Enterprise library and another Dotnet based database abstraction layer to query SQL Server. However, on deployment, when requesting data through both abstraction layers, I receive the generic SQL Server does not exist or access denied. However, I have validated the configuration of Enterprise library by creating a simple diagnostics console app that uses the exact enterprise library configuration file and this can connect without a problem. It seems like only web applications are affected though this is fairly standard web app using ASPNET, user , no impersonation etc. Therefore I suspect something similar to permissions on dlls or similar. I have looked around at Windows, WindowsSystem 32, the Dotnet framework but can anyone suggest any other areas to look at?
View 1 Replies
View Related
Oct 7, 2006
Error: SQL Server does not exist or access denied.string select="select trainerid from trainer where username='"+user+"'";Line 78: comm=new SqlCommand(select,con);Line 79: con.Open();Line 80: dr=comm.ExecuteReader();Line 81: while(dr.Read())where should i set this so that the sqlserver can be access.. 1 private void btnsubmit_Click(object sender, System.EventArgs e)
2 {
3 string user=TextBox1.Text;
4 string password=TextBox2.Text;
5 Session["uname"]=TextBox1.Text;
6 Session["logintime"]=DateTime.Now.ToString("dd MMM, yyyy");
7 string connectionstring=ConfigurationSettings.AppSettings["connstring"].ToString();
9 con=new SqlConnection(connectionstring);
10 string select="select trainerid from trainer where username='"+user+"'";
11 comm=new SqlCommand(select,con);
12 con.Open();
13 dr=comm.ExecuteReader();
14 while(dr.Read())
15 {
16 Session["trainerid"]=dr["trainerid"].ToString();
17 }
18
19 Response.Redirect("tmenu.aspx");
20 if(CheckBox1.Checked=true)
21 {
22
23
24 DateTime dt=DateTime.Now;
25 TimeSpan ts=new TimeSpan(0,0,1,0);
26 HttpCookie cookie2=new HttpCookie("Username1");//creating http cookies
27 cookie2.Values.Add("name",user); //assigning first key value
28 cookie2.Values.Add("pword",password); //assigning second key value
29 cookie2.Expires=dt.Add(ts); //assigning the expires of cookie
30 Response.Cookies.Add(cookie2); //stored cookie to the client machine cookie folder
31
32 }
33
34
35 }
View 18 Replies
View Related
Nov 30, 2006
Does the error below look familiar to anybody? I cannot seem to get past it! My connection code is
<sessionState mode="SQLServer" stateConnectionString="tcpip=BRAHMA" sqlConnectionString="data source=epscor;user id=epscorser;password=epsc0r" cookieless="false" timeout="60"/>
Help in solving this appreciated! -Steve
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Web.SessionState.SqlStateConnection..ctor(String sqlconnectionstring) +92
[HttpException (0x80004005): Unable to connect to SQL Server session database.]
System.Web.SessionState.SqlStateConnection..ctor(String sqlconnectionstring) +189
System.Web.SessionState.SqlStateClientManager.GetConnection(Boolean& usePooling) +98
System.Web.SessionState.SqlStateClientManager.SetAsyncWorker(String id, SessionStateItem item, Byte[] buf, Int32 length, Boolean inStorage) +44
System.Web.SessionState.SqlStateClientManager.System.Web.SessionState.IStateClientManager.Set(String id, SessionStateItem item, Boolean inStorage) +147
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +465
System.Web.SessionState.SessionStateModule.OnEndRequest(Object source, EventArgs eventArgs) +44
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87
View 7 Replies
View Related
Feb 8, 2007
Hello everyone,
I’m hoping that someone could help explain why I get this error “SQL Server does not exist or access denied.� . I’ve migrated to the web server from my local machine and these are the steps I took:
1.Copied folder to web server.
2. Changed connection string to connect to DB
3. modified web.config
Being the first time I’ve done this I’m also posting the connection string and config file code.
this.sqlConnect.ConnectionString = "Provider=sqloledb;Data Source=serverAddress;Initial Catalog=myDB;User Id=myLogin;Password=myPass";
I changed it from this:
this.sqlConnect.ConnectionString = "workstation id=myComputerName;packet size=4096;integrated security=SSPI;data source=myComputerName;pers" + "ist security info=False;initial catalog=blog";
the config file:
<sessionState
mode="InProc"
stateConnectionString="tcpip=mssql.mySqlSource.com:42424"
sqlConnectionString="data source=mssql.mySqlSource.com;Trusted_Connection=yes"
cookieless="false"
timeout="20"
/>
Question- that port number, does it need to be changed?
I know that the server is running both 1.1 and 2.0 framework. Not sure if that could be an issue or not.
In Advance I want to say thanks for any support I receive.
The Fatthippo.
View 8 Replies
View Related
Feb 16, 2007
We have sql server with the name production1 (IPID:100.102.33.33) ,from asp.net iam able to connect properly ,yesterday we changed the ip Id of this system(production1) from that time if iam trying to connect from asp.net code it is giving error sqlserver does not exists access denied.
Iam able to connect in query analyzer by using same userid,password.
Iam able to connect in vb.net with same connection string which iam using in asp.net
Iam unable to connect in asp.net error sqlserver does not exists access denied.
Please help me is there any problem with asp user or what?
Thanks
View 17 Replies
View Related
Nov 5, 2007
Hi,
Iam using a connection string to connectin sql server from asp.net (vesion 1.1).
When iam using same connection string in windows form it is connecting to sql server proplery.
Iam using the same connection in asp.net (web based page) but is saying an error "SQL Server does not exists or access denied".
From Query analyzer iam able to connect to sql server.
Please let me know the reason .
Thanks,
ASwani kumar
View 8 Replies
View Related
Jan 6, 2008
I think its my server because I cant get it to link up to an Access data base either, heres the error I get.[DBNETLIB]ConnectionOpen (Connect()),]SQL Server does not exist or access denied.Im pretty sure that all the fields that I entered are correct though.What could be the problem? Someone mentioned that the network protocol configuration maybe isnt setup right. Could this be the problem? If so how would I properly configure this?
View 14 Replies
View Related
Jun 17, 2008
I've got a SQL2000 named instance on a box that also has SQL 2005. Both database versions have run side by side for some time and I don't USUALLY have a problem (famous last words!).
I'm currently getting the error in the subject line trying to connect to it as "MACHINENAMESQL2000", SQL2000 being the named instances, from another machine. It works fine from the local machine, naturally. I have verified my creditials, i.e. both Windows Authentication and a SQL login work fine from the local machine. The machines are physically on the same subnet (they're actually side by side) and both can talk to each other just fine, i.e. they ping, and can map drives, etc.
Any tips/ideas on how to trouble shoot this? Is there a new security switch that needs to be set to make the db visible to other machines??
-Confused
View 1 Replies
View Related
Nov 12, 2003
I' ve wrote the following simple asp.net code to test the connection to my local SQL server:
SqlConnection connection = new SqlConnection ("server=localhost;uid=sa;pwd=;database=pubs");
try
{
connection.Open();
}
catch(SqlException ex){
Label1.Text= ex.Message;}
finally{
connection.Close();}
But each time I got the following errors:
SQL Server does not exist or access denied.
Can anyone help me find out when my problem lies?
BTW, the SQL service in Control Panel has been started, and my local SQL server uses windows and SQL authentication. When I use osql -E -S MyMachineName(This MyMachineName is some kind SQL Server Registration in SQL Server Group of SQL Server Enterprise Manage), everything seems to be fine, but it does not work when I use osql -E -S localhost.
View 3 Replies
View Related
Nov 14, 2003
Trying to get Quickstart tuts up and running. I get this error whenever i try to run any examples.
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
I installed the MSDE (i think) and i see the service MSSQL server running.
I don't see the icon in the system try that shows SQL server is running. I don't even know how to check to see if the MSDE is installed. There is nothing in my Start>>Program Files MSDE related. What am i doing wrong? Thanks!
View 5 Replies
View Related
Nov 17, 2003
Trying to get the Quickstarts up and running. When i go to one of the server side data access tutorials i get the error: SQ: server does not exist or access denied. I am using SQL server 2000. Any reason i would be seeing this?
Also, to see the quickstarts i have to browse to httP://localhost/quickstart/.....if i try to go to http://machinename/quickstart/ i get access denied. Any reason for that?
Thanks for any help.
View 1 Replies
View Related
Nov 25, 2003
I'm getting the following error when I run my web app:
SQL Server does not exist or access denied.
I created a role in my db and added a user to that role.
I gave the user the appropriate permissions.
I also gave the user the appropriate permissions to my tables.
Thank you,
Tina
View 11 Replies
View Related
Dec 12, 2003
Hi,
I get the following error when I try to access SQL Server:
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
and I also get the following Warning in the System Log
The server was unable to logon the Windows NT account 'ECOM411-BOYSSWGASPNET' due to the following error: Logon failure: unknown user name or bad password. The data is the error code.
I have settup the account 'ECOM411-BOYSSWGASPNET' on the SQL Server and have given it access to the my DB... Could some one tell me what could be wrong??
How can I fix this probelm..
Thanks
View 6 Replies
View Related
Dec 19, 2003
I have 2 servers. one is the web server and the other is the sql server. web server(iis) is on windows 2000 and sql server is hosted on windows 2003
i can't connect to the sQL Server hosted on my Windows 2003 machine from an asp.net application. This is the error message i am getting. "SQL Server does not exist or access denied."
The sql server is set for both windows and sql server authentication. I have no problem connecting to it from the Web server using Enterprise Manager or Query Analyser.
The password is correct and username sa has full access.
This is the code i am using. the code is fine. i have used it 100s of time. the code below will work if i change the data source to "localhost" to connect to the sql server that is hosted on the same machine.
Dim strCon As String
strCon = "data source=Data1;initial catalog=MyFriendsNet;password=blah;persist security info=True;user id=sa;workstation id=Web1;packet size=4096"
Dim MyConnection As SqlConnection = New SqlConnection(strCon)
Dim MyCommand As SqlCommand = New SqlCommand("Select * FROM Users", MyConnection)
MyConnection.Open()
Dim MyDr As SqlDataReader = MyCommand.ExecuteReader
While MyDr.Read()
Response.Write(MyDr("FirstName"))
End While
MyDr.Close()
MyConnection.Close()
This probably has to do with some kind of authentication issue. anyone have any ideas.
View 3 Replies
View Related
Feb 11, 2004
Hi,
When i am running web server IIS 5.0 and SQL Server 2000 in the same machine, the following connection strings is working well:
server=(local);uid=sa;pwd='';database=databaseName
But, when i try to run Web Server IIS 5.0 on machnine A and SQL Server 2000 on machine B. The connection strings for connecting to the database server is:
server=serverName;uid=sa;pwd='';database=databaseName
The following error occurs:
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Source Error:
Line 70: myCommand.CommandType = CommandType.Text
Line 71: ' Execute the command
Line 72: myConnection.Open()
Line 73: Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 74:
Source File: c:inetpubwwwrootPSRBNetDesktopModulesCirrusMembershipDB.vb Line: 72
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
PSRBNet.Cirrus.MembershipDB.GetSingerMemberInfo(String MemberID) in c:inetpubwwwrootPSRBNetDesktopModulesCirrusMembershipDB.vb:72
PSRBNet.Cirrus.Test.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootPSRBNetDesktopModulesCirrusTest.aspx.vb:534
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Anyone facing this problem before? please help...
View 4 Replies
View Related
Apr 21, 2004
Hi All, I'm working from the tutorials section of this site.
The code is below:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter
MyConnection = New SqlConnection("server=(local)NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection)
DS = new DataSet()
MyCommand.Fill(ds, "Authors")
MyDataGrid.DataSource=ds.Tables("Authors").DefaultView
MyDataGrid.DataBind()
End Sub
</script>
<body>
<h3><font face="Verdana">Simple Select to a DataGrid Control</font></h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/>
</body>
</html>
This is the error:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
Hope you can help.
Thanks,
Dermot
View 20 Replies
View Related
Jun 11, 2004
As shown by the post topic, I am trying to connect to a remote sql server through enterprise manager, and have been getting "SQL Server does not exist or access denied".
I have disabled Named Pipes, made sure it's listening on port 1433, triple-checked the user account, etc. Still nothing. The server is behind an ISA server, that has packet filtering turned on for 1433 also, yet I can't help but think the ISA server is to blame....
I am baffled after reading multiple tech docs and forum posts.
ANY HELP would be GREATLY APPRECIATED. (I'm pulling my hair out).
View 4 Replies
View Related
