Error Trying To Connect To Reporting Services Using SQL Management Studio

Jul 13, 2007

Hi.

I have some strange error trying to connect to Reporting Services.

At the beginning I was suspecting some accounts issues.

But after checking all the accounts under wich ASP.NET, SQL SERVER, Reporting Services are running I don't even know what to think.

After searching internet for answers the only similar problems' solutions were remove RS and install it again.

Have anybody here had this problem? Can you just fix something without reinstalling RS? The error is:

Object reference not set to an instance of an object

------------------------------
Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()

View 2 Replies

Can't Connect Management Studio To Reporting Services

Jun 20, 2007

Hi,

I'm trying to connect Management Studio to Reporting services on my local machine, but get this message:

Code Snippet

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Compilation Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Compilation Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
<br><br>

<b> Compiler Error Message: </b>CS0246: The type or namespace name 'Site' could not be found (are you missing a using directive or an assembly reference?)<br><br>
<b>Source Error:</b><br><br>
<table width=100% bgcolor="#ffffcc">
<tr><td>
</td></tr>
<tr>
<td>
<code><pre>

[No relevant source lines]</pre></code>

</td>
</tr>
</table>

<br>

<b>Source File:</b> c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs
<b>Line:</b> 19
<br><br>
<br><div class="expandable" onclick="OnToggleTOCLevel1('compilerOutputDiv')">Show Detailed Compiler Output:</div>
<div id="compilerOutputDiv" style="display: none;">
<br><table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

C:WINDOWSsystem32> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450assemblydl378d258ab0f57899_d34cc701ReportingServicesWebServer.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.1.cs"

Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1318
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs(19,20): error CS0246: The type or namespace name 'Site' could not be found (are you missing a using directive or an assembly reference?)
</pre></code>

</td>
</tr>
</table>

</div>

<script type="text/javascript">
function OnToggleTOCLevel1(level2ID)
{
var elemLevel2 = document.getElementById(level2ID);
if (elemLevel2.style.display == 'none')
{
elemLevel2.style.display = '';
}
else {
elemLevel2.style.display = 'none';
}
}
</script>
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.1318; ASP.NET Version:2.0.50727.1318

</font>

</body>
</html>

--. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------
Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Anyone got any ideas?

Thanks,

Martin.

View 1 Replies View Related

Cannot Connect To Reporting Services Using IE Or Sql Server Management Studio

Dec 27, 2007

I have installed 2005 in a new machine with reporting services and configured the reporting services fine. I see the virtual directories fine in IIS but when I try connecting to the report server using IE (http://localhost/reports or http://servername/reports) i get page cannot be displayed errro. When I try connecting using management studio I get the following error

TITLE: Connect to Server
------------------------------
Cannot connect to BLRPTSQL03T.
------------------------------
ADDITIONAL INFORMATION:
The underlying connection was closed: An unexpected error occurred on a receive. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
------------------------------
An existing connection was forcibly closed by the remote host (System)
------------------------------
BUTTONS:
OK
------------------------------

I donot see any errors in the event logs or the report server logs. Any help with this issue greatly appreciated

View 3 Replies View Related

Can't Connect To SQL Reporting Services Through IIS And SQL Server Management Studio

Aug 3, 2007

Hi,

I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. I have also check the reporting services configurations manager for any issues but still can't connect. The http://localhost/reportserver also is down. I also checked if ASPNET account belongs to the Reporting Services security settings and it does. IIS is up and running.

I'm running SQL 2005 Enterprise 64bit with Service Pack 2.

===================================

Cannot connect to ctbbcysql02.

===================================

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------
Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Any help will be greatly appreciated.

Regards,

Ruaan

View 1 Replies View Related

Can't Connect To Reporting Services Using Microsoft SQL Server Management Studio

Sep 15, 2006

When I try to connect to the Reporting Services using Microsoft SQL Server Management Studio, the following error message propmpts up:

_____________________________________________________________
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
_____________________________________________________________

Is there any settings that I need to do in the "Reporting Services Configuration Manager" ?

Thanks.

Best regards,

Michael Wu

View 1 Replies View Related

Cannot Connect To Reporting Services Using Microsoft Sql Server Management Studio.

Nov 19, 2005

Hi,

View 8 Replies View Related

Reporting Services 2005 And SQL Server Management Studio Connection Error

Oct 5, 2007

I have installed multiple instances of SSRS on same server with different database. I can go to the report server URL for both SSRS and run reports. But I cannot connect to the 2nd instance through "SQL Server Management Studio". Also
I am getting following error when I try to connect to the "Reporting services configuration" tool from a remote machine

Code Block
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.Management.ManagementException: Not found
at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.PropertyData.RefreshPropertyInfo()
at System.Management.PropertyDataCollection.get_Item(String propertyName)
at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName)
at System.Management.ManagementBaseObject.get_Item(String propertyName)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.get_IsSharePointIntegrated()
at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
at System.Windows.Forms.Form.set_Active(Boolean value)
at System.Windows.Forms.Form.WmActivate(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
RSConfigTool
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/RSConfigTool.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.832 (QFE.050727-8300)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
----------------------------------------
System.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

View 5 Replies View Related

Problem Opening Reporting Services In SQL 2005 Management Studio

Jan 23, 2008

Please can you help me...

I am unable to open reporting services on my SQL 2005 server.
How can I open it??
It falls over with the following:

TITLE: Connect to Server

------------------------------

Cannot connect to L00000001DEV1.

------------------------------

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

The request failed with the error message:

--

<html>

<head>

<title>Compilation Error</title>

<style>

body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}

p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}

b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}

H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }

H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }

pre {font-family:"Lucida Console";font-size: .9em}

.marker {font-weight: bold; color: black;text-decoration: none;}

.version {color: gray;}

.error {margin-bottom: 10px;}

.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

</style>

</head>

<body bgcolor="white">

<span><H1>Server Error in '/ReportServer$ILDEV1' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Compilation Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

<br><br>

<b> Compiler Error Message: </b>CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.dll' -- 'Access is denied. '<br><br>

<b>Source Error:</b><br><br>

<table width=100% bgcolor="#ffffcc">

<tr><td>

</td></tr>

<tr>

<td>

<code><pre>

[No relevant source lines]</pre></code>

</td>

</tr>

</table>

<br>

<b>Source File:</b>

<b>Line:</b> 0

<br><br>

<br><div class="expandable" onclick="OnToggleTOCLevel1('compilerOutputDiv')">Show Detailed Compiler Output:</div>

<div id="compilerOutputDiv" style="display: none;">

<br><table width=100% bgcolor="#ffffcc">

<tr>

<td>

<code><pre>

c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver$ildev1575b41e7ef9faab0assemblydl3e595e3cb025f0d5_c24cc701ReportingServicesWebServer.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.1.cs"

Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.42

for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727

Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver$ildev1575b41e7ef9faab0App_global.asax.eki-3joz.dll' -- 'Access is denied. '

</pre></code>

</td>

</tr>

</table>

</div>

<script type="text/javascript">

function OnToggleTOCLevel1(level2ID)

{

var elemLevel2 = document.getElementById(level2ID);

if (elemLevel2.style.display == 'none')

{

elemLevel2.style.display = '';

}

else {

elemLevel2.style.display = 'none';

}

}

</script>

<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

</font>

</body>

</html>



--. (Microsoft.SqlServer.Management.UI.RSClient)

------------------------------

BUTTONS:

OK

------------------------------

View 6 Replies View Related

Query That Works In Management Studio, Fails In Reporting Services

May 30, 2007

I can run the following query in Management Studio, but get the error listed below when I run it from the data tab in Reporting Services:

declare @starttime as datetime
declare @endtime as datetime
declare @timezone as integer
declare @date as datetime

set @timezone = 1
set @date = '5/1/2007'

set @starttime = dateadd(hh, @timezone, @date)
set @endtime = dateadd(d, 1, @starttime)

select @Starttime, @endtime from site

Error Message:

TITLE: Microsoft Report Designer
------------------------------

An error occurred while executing the query.
The variable name '@starttime' has already been declared. Variable names must be unique within a query batch or stored procedure.

------------------------------
ADDITIONAL INFORMATION:

The variable name '@starttime' has already been declared. Variable names must be unique within a query batch or stored procedure. (Microsoft SQL Server, Error: 134)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=134&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

What I am trying to accomplish is the ability for users to select which time zone they want the data in the report to display in. To do this, I created a timezone parameter that has the offset from Central Time (which is how all data is stored in our database).

Any help would be greatly appreciated!

View 4 Replies View Related

Reporting Services :: Format Painter In SS Management Studio Report Design?

Mar 22, 2009

Is Format Painter is available in SQL Server Management Studio Report Design?If not, any other way can we copy format?

View 4 Replies View Related

Cannot Connect To SQL Report Server Through Web As Well As Management Studio (Http:503 Error Service Unavailable.)

Apr 10, 2007

hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

"http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

===================================

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

View 1 Replies View Related

Can't Access Reporting Services In Management Studio Or Web Interface Using Windows Integrated Security

May 12, 2008

I know from searching this forum that there have been many variations of the issue I'm currently suffering, but I haven't found anything quite like mine or a solution to solve it. The issue I'm running into is that I am unable to log on to Reporting Services using Management Studio or the web interface when Windows Integrated Security is enabled. I have full functionality using basic security, but the risks involved make it impossible to deploy basic authentication out into production. The error I'm receiving in Management Studio is The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient). I recieve the same error when I try the web interface.

I've looked the most recent logfile in WindowsSystem32LogFilesW3SVC1 and these entries match up to the time I attempted my authentication.

Code Snippet
2008-05-12 20:30:42 <Edited: Server IP> GET /reports - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:42 <Edited: Server IP> GET /reports - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 301 0 0
2008-05-12 20:30:42 <Edited: Server IP> GET /reports/ - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:46 <Edited: Server IP> GET /reports/home.aspx - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 302 0 0
2008-05-12 20:30:46 <Edited: Server IP> GET /reports/Pages/Folder.aspx - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:47 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2008-05-12 20:30:47 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2008-05-12 20:30:47 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 2148074248
2008-05-12 20:30:49 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 2 2148074254
2008-05-12 20:30:49 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 0
2008-05-12 20:30:49 127.0.0.1 POST /ReportServer/ReportService2005.asmx - 80 - 127.0.0.1 - 401 1 2148074248
2008-05-12 20:30:50 <Edited: Server IP> GET /reports/Pages/Folder.aspx - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 500 0 0
2008-05-12 20:30:50 <Edited: Server IP> GET /Reports/js/ReportingServices.js - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:50 <Edited: Server IP> GET /Reports/js/ReportingServices.js - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/styles/ReportingServices.css - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/images/blank.gif - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/images/blank.gif - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/images/48error.jpg - 80 - <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/styles/ReportingServices.css - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2008-05-12 20:30:54 <Edited: Server IP> GET /Reports/images/48error.jpg - 80 DomainUserName <Edited: Server IP> Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2008-05-12 20:31:07 127.0.0.1 GET /reports/ - 80 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:31:07 127.0.0.1 GET /reports/ - 80 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 1 0
2008-05-12 20:31:13 127.0.0.1 GET /reports/ - 80 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 2 2148074254
2008-05-12 20:31:13 127.0.0.1 GET /reports/ - 80 - 127.0.0.1 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.2;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 401 1 0

I tried to highlight one of each of the HTTP errors I am getting. 401.2 and 401.1 are the ones I kind of expected, but have no idea why I'm getting them. The 500 0 error is a bit troubling, because unless I'm mistaken thats a server side error.

Here's my current setup. As far as I can tell, I've done everything to set up correctly for Windows Integerated security.

My Specs
The server machine running all SQL 2005 services. It resides in a domain. All Clients are in the same domain.

Intel Dual Processor 3.20 gig Xenon

Windows Server 2003 w/ SP2

Microsoft Sql Server 2005 w/ SP2
Reporting Services Setup
The virtual directories Reports and ReportServer are set to Windows Integrated Security with Anonymous Access disabled. All other checkboxes in Directory Security are unchecked. For permissions in Reports, I have:

Administrators (servernameAdministrators) - Full Control

ASP.NET Machine Account - Modify, Read & Execute, List Folder Contents, Read, Write

Authenticated Users - Modify, Read & Execute, List Folder Contents, Read, Write

Creator Owner - No permissions

Domain Users - Read & Execute, List Folder Contents, Read

SQLServer2005ReportingServices]WebServiceUsers$... - Read & Execute, List Folder Contents, Read

SQLServer2005ReportServerUsers$... - Read & Execute, List Folder Contents, Read

SYSTEM - Full Control

Users (CompNameUsers) - Read & Execute, List Folder Contents, Read
In ReportServer I have the same permissions except Authenticated Users is absent.

At one point, I even added the account Everybody and gave it full control, and I still recieved a HTTP 401 error. Any help at what I might be missing would be a godsend.

Thanks.

View 1 Replies View Related

Can't Connect Through Management Studio Only

Aug 29, 2007

Hi,

I am having a very frustrating problem trying to connect to a remote SQL Server 2005 at my ISP. When I try to connect through Management Studio the ISP SQL Server returns an error of 'Login failed for user xxx (18456)'.

According to the ISP they can see my connection attempt in their logs.

However, I can access the same SQL Server through Visual Studio, and UDL files using exactly the same credentials.

The ISP have given up, and this is driving me crazy!

I will be very, very grateful for any help or suggestions.

Thanks,
Martin

View 3 Replies View Related

Cannot Connect From Management Studio When Using TCP

Apr 9, 2007

I can connect to my SQLEXPRESS on the same box when I use the default connection, but when I specify TCP/IP in the Network Protocol, I get the dreaded (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified).

I can access the port with telnet and I can run "SQLCMD -S TCP:<servername>SQLEXPRESS,1433 -U username -P password -q"Select * from <table>" and they both work fine.

Ultiimately my goal is to connect via IIS and PHP, but that is failing right now and I figure it'll keep failing until I can connect Management Studio using TCP.

I can also run the SQLCMD from my other box when the firewall is shutdown. I'm out of ideas? Any thoughts?

View 4 Replies View Related

Unable To Connect To SQL Management Studio

Mar 22, 2007

I��m unable to connect to SQL Management Studio. I get the following error:

===================================

Cannot connect to serverabc

. ===================================

Client found response content type of 'text/html; charset=Windows-1252', but expected 'text/xml'. The request failed with the error message: --

body
{font-family:'Verdana';font-weight:normal;font-size:.7em;color:black;}
p
{font-family:'Verdana';font-weight:normal;color:black;margin-top:-5px;}
b
{font-family:'Verdana';font-weight:bold;color:black;margin-top:-5px;}
H1
{font-family:'Verdana';font-weight:normal;font-size:18pt;color:red;}
H2
{font-family:'Verdana';font-weight:normal;font-size:14pt;color:maroon;}
pre
{font-family:'Lucida Console';font-size:.9em;}
.marker
{font-weight:bold;color:black;text-decoration:none;}
.version
{color:gray;}
.error
{margin-bottom:10px;}
.expandable
{text-decoration:underline;font-weight:bold;color:navy;cursor:hand;}

Server Error in '/' Application.

Server cannot access application directory '\{server}{share}'. The directory does not exist or is not accessible because of security settings. 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.HttpException: Server cannot access application directory '\{server}{share}'. The directory does not exist or is not accessible because of security settings.

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:

[HttpException (0x80004005): Server cannot access application directory '\{server}{share}'. The directory does not exist or is not accessible because of security settings.]
System.Web.HttpRuntime.EnsureAccessToApplicationDirectory() +72
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +263

[HttpException (0x80004005): ASP.NET Initialization Error]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +982
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +128

Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 --. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ Program Location: at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection() at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString) at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject() at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci) at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

I believe the problem is the server has ASP 1.1 and ASP 2.0 installed and Management Studio is trying to use ASP 1.1 (see highlight section). If I go into IIS and disable ASP 1.1 I get an 404 error when trying to connect to Management Studio. Is there a way to force Management Studio to use ASP 2.0? I can't uninstall ASP 1.1 because this is a dev server and other apps use ASP 1.1.

View 2 Replies View Related

Can't Connect To SQL Server Management Studio Through VPN

Sep 10, 2007

Hi,

I am currently looged into the OS (windows xp pro,belongs to domian ABC) as user vdm.
I have connected to VPN for a client and would now like to connect to their sql server database using sql server management studio. This sql server installation is on a remote domain called XYZ.

When I open sql server studio and select windows authentication, my local domain ABC is selected and greyed out...I would like to change this to XYZ domain...how to achieve this ?

thanks in advance

View 5 Replies View Related

Cannot Connect Via C# But Can Via Server Management Studio

Feb 6, 2008

When I try to connect to my sql server 2005, from a asp.net web application (asp.net development server) using...

Database=Prism_Project_db; Server=(local); Integrated Security=SSPI; MultipleActiveResultSets=True

... as the connection string, i get:

Cannot open database "Prism_Project_db" requested by the login. The login failed.
Login failed for user 'R-LAPTOPRyan Holdren'.Yet I can connect using sql server management studio, no problem:

Server Type: Database Engine
Server: R-Laptop
Authentication: Windows Authentication

which connects as "R-LAPTOPRyan Holdren".

I do not understand how the login could work for one application and not for another. Can anyone help me get this working?

Ryan

View 8 Replies View Related

Cannot Connect To Database In Server Management Studio

Dec 22, 2005

THIS IS DRIVING MY CRAZY!!!!

I currently can't connecto to my database in SQL Server 2005 (enterprise) but as soon as I try to use any functions, I get cryptic errors found below. I am about to pull my hair out. Everything was working fine for around 4 days and now everything just blows up. I've tried using both sql authentification and also windows:

Errors I'm getting (print screens):

http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc

SQL logs:

http://www.photopizzaz.biz/junk/logs.txt

Event log errors are:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17809
Date: 12/21/2005
Time: 11:18:34 PM
User: N/A
Computer: BG-SQL2005
Description:
Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 91 45 00 00 14 00 00 00 �E......
0008: 0b 00 00 00 42 00 47 00 ....B.G.
0010: 2d 00 53 00 51 00 4c 00 -.S.Q.L.
0018: 32 00 30 00 30 00 35 00 2.0.0.5.
0020: 00 00 00 00 00 00 ......

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 12/21/2005
Time: 10:34:03 PM
User: N/A
Computer: BG-SQL2005
Description:
Login failed for user 'sa'. [CLIENT: <local machine>]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 0b 00 00 00 42 00 47 00 ....B.G.
0010: 2d 00 53 00 51 00 4c 00 -.S.Q.L.
0018: 32 00 30 00 30 00 35 00 2.0.0.5.
0020: 00 00 07 00 00 00 6d 00 ......m.
0028: 61 00 73 00 74 00 65 00 a.s.t.e.
0030: 72 00 00 00 r...
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 8561
Date: 12/21/2005
Time: 10:19:51 PM
User: N/A
Computer: BG-SQL2005
Description:
Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 71 21 00 00 0a 00 00 00 q!......
0008: 0b 00 00 00 42 00 47 00 ....B.G.
0010: 2d 00 53 00 51 00 4c 00 -.S.Q.L.
0018: 32 00 30 00 30 00 35 00 2.0.0.5.
0020: 00 00 07 00 00 00 6d 00 ......m.
0028: 61 00 73 00 74 00 65 00 a.s.t.e.
0030: 72 00 00 00 r...
Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date: 12/21/2005
Time: 4:46:14 PM
User: N/A
Computer: BG-SQL2005
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

View 1 Replies View Related

Cannot Connect To Database In Server Management Studio

Dec 22, 2005

I currently can't connecto to my database in SQL Server 2005 (enterprise) but as soon as I try to use any functions, I get cryptic errors found below. I am about to pull my hair out. Everything was working fine for around 4 days and now everything just blows up. I've tried using both sql authentification and also windows:

Errors I'm getting (print screens):

http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc

SQL logs:

http://www.photopizzaz.biz/junk/logs.txt

Event log errors are:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17809
Date:  12/21/2005
Time:  11:18:34 PM
User:  N/A
Computer: BG-SQL2005
Description:
Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 91 45 00 00 14 00 00 00   ?E......
0008: 0b 00 00 00 42 00 47 00   ....B.G.
0010: 2d 00 53 00 51 00 4c 00   -.S.Q.L.
0018: 32 00 30 00 30 00 35 00   2.0.0.5.
0020: 00 00 00 00 00 00         ......

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date:  12/21/2005
Time:  10:34:03 PM
User:  N/A
Computer: BG-SQL2005
Description:
Login failed for user 'sa'. [CLIENT: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00   .H......
0008: 0b 00 00 00 42 00 47 00   ....B.G.
0010: 2d 00 53 00 51 00 4c 00   -.S.Q.L.
0018: 32 00 30 00 30 00 35 00   2.0.0.5.
0020: 00 00 07 00 00 00 6d 00   ......m.
0028: 61 00 73 00 74 00 65 00   a.s.t.e.
0030: 72 00 00 00               r...

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 8561
Date:  12/21/2005
Time:  10:19:51 PM
User:  N/A
Computer: BG-SQL2005
Description:
Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 71 21 00 00 0a 00 00 00   q!......
0008: 0b 00 00 00 42 00 47 00   ....B.G.
0010: 2d 00 53 00 51 00 4c 00   -.S.Q.L.
0018: 32 00 30 00 30 00 35 00   2.0.0.5.
0020: 00 00 07 00 00 00 6d 00   ......m.
0028: 61 00 73 00 74 00 65 00   a.s.t.e.
0030: 72 00 00 00               r...

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date:  12/21/2005
Time:  4:46:14 PM
User:  N/A
Computer: BG-SQL2005
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

View 4 Replies View Related

Cannot Connect To Database In Server Management Studio

Dec 22, 2005

I currently can't connecto to my database in SQL Server 2005 (enterprise) from the SQL Server Management Studio itself! as soon as I try to use any functions, I get cryptic errors found below. I am about to pull my hair out. Everything was working fine for around 4 days and now everything just blows up. I've tried using both sql authentification and also windows:

Errors I'm getting (print screens):

http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc

SQL logs:

http://www.photopizzaz.biz/junk/logs.txt

Event log errors are:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17809
Date:  12/21/2005
Time:  11:18:34 PM
User:  N/A
Computer: BG-SQL2005
Description:
Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 91 45 00 00 14 00 00 00   ?E......
0008: 0b 00 00 00 42 00 47 00   ....B.G.
0010: 2d 00 53 00 51 00 4c 00   -.S.Q.L.
0018: 32 00 30 00 30 00 35 00   2.0.0.5.
0020: 00 00 00 00 00 00         ......

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date:  12/21/2005
Time:  10:34:03 PM
User:  N/A
Computer: BG-SQL2005
Description:
Login failed for user 'sa'. [CLIENT: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00   .H......
0008: 0b 00 00 00 42 00 47 00   ....B.G.
0010: 2d 00 53 00 51 00 4c 00   -.S.Q.L.
0018: 32 00 30 00 30 00 35 00   2.0.0.5.
0020: 00 00 07 00 00 00 6d 00   ......m.
0028: 61 00 73 00 74 00 65 00   a.s.t.e.
0030: 72 00 00 00               r...

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 8561
Date:  12/21/2005
Time:  10:19:51 PM
User:  N/A
Computer: BG-SQL2005
Description:
Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 71 21 00 00 0a 00 00 00   q!......
0008: 0b 00 00 00 42 00 47 00   ....B.G.
0010: 2d 00 53 00 51 00 4c 00   -.S.Q.L.
0018: 32 00 30 00 30 00 35 00   2.0.0.5.
0020: 00 00 07 00 00 00 6d 00   ......m.
0028: 61 00 73 00 74 00 65 00   a.s.t.e.
0030: 72 00 00 00               r...

Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Management
Event ID: 107
Date:  12/21/2005
Time:  4:46:14 PM
User:  N/A
Computer: BG-SQL2005
Description:
Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

View 8 Replies View Related

Local Management Studio Cannot Connect To Remote IS

Feb 20, 2006

I am not able to connect my local SQL Server Management Studio to a remote server hosting our Integration Services. I get the infamous "Access Denied". I have walked through Kirk Haselden's howto at:

http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

but the problem persists.

Thanks for any help.

Keehan

View 8 Replies View Related

Can't Connect To Report Server Via Management Studio

Nov 30, 2005

Hi,

View 33 Replies View Related

SQL Server Management Studio 2005 Can't Connect

May 7, 2007

New server - Windows 2003 with latest patches (always up to date)

Symantec Antivirus Coporate Edition 10.1

SQL 2005 Workgroup Edition

If I run SQL Server Management Studio, it connects fine to the server.

Then attach a datafile for my application which is installed on the server.

I can run app and open database. All works fine.

Then if I try to run SQL Server Management Studio again it can't connect:

TITLE: Connect to Server
------------------------------

Cannot connect to HACSRV03.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

This server is not a production server, as only just installing - like it works fine and then just fails without warning.

Help!!!

View 1 Replies View Related

Help! Getting Errors When Trying To Connect To SQL Server Management Studio

Jun 9, 2006

Hi All,

I have Windows 2003 Server with MSSQL 2005 Standard.

I am able to connect via Windows Authentication, but when I try to change it to SQL Server Authentication with user 'sa' I'm then being prompted with the error msg:

A connection was successfully established with the server, but then an
error occurred during the login process. (provider: Shared Memory
Provider, error: 0 - No process is on the other end of the pipe.) (.Net
SqlClient Data Provider)

Here is the entire list of msgs that are showing up:

===================================

Cannot connect to SOLELL-QGL5PG9D.

===================================

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

------------------------------
Server Name: SOLELL-QGL5PG9D
Error Number: 233
Severity: 20
State: 0

------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Any pointers?

-Alon.

View 7 Replies View Related

Can I Use SQL 2005 Management Studio To Connect To SQL 2000 Server?

Oct 12, 2007

Hi,Can I use SQL 2005 Management studio to connect to SQL 2000 server?

View 1 Replies View Related

Cannot Connect To SQL Server Express Edition Using Its Management Studio

Mar 17, 2008

Please, I use tyhe Visual Studion 2005 SQL Server Express Edition Management Studio (SMSE) to create the backend database and trying to set the connectionstring from the web config file, but what I continue to get as an error is that "<computername>/ASPNET" login failed for that user, cannot login to the Management Studio.
This is my expression from the web config file
<connectionStrings><clear /><add name="LocalSqlServer" connectionString="Data Source=.SQLEXPRESS; Database=<dbname>;User Instance=true; Integrated Security=true" providerName="System.Data.SqlClient" />
</connectionStrings>
Is there anything I do wrong? Please, I need to solve this and it's urgent.Thanks
Kayode Banjo
Programmer

View 1 Replies View Related

Can You Connect To An Oracle DB Using MS Sql Server Management Studio Express?

Sep 27, 2007

Hi Everyone,

Just like the title says:

Can you connect to an Oracle DB using MS Sql Server Management Studio Express?

If so, can anyone please give me an example?

Thanks heaps!

View 7 Replies View Related

Cannot Connect To Report Server From Management Studio Express

Apr 7, 2008

hello there,

I appreciate any help on the following issue:

When I want to connect to a local report server on as shown in the "Reporting Services Tools" tutorial (http://msdn2.microsoft.com/en-au/library/aa337424.aspx), the SSMSE does not show the option "Reporting Services" in the "Server type" drop down list in the "Connect to server" dialog.

The tutorial says "In the Server type list, select Reporting Services. If Reporting Services is not on the list, it is not installed."

This must be wrong as the SSCM clearly shows an installed and running "SQL Server Reporting Service (...)".

Also if i call the webinterface (http://localhost/reports/) a page loads that says "SQL Server Reporting Services Home" with some options. And here something is not correct too. The "contents" tab of the report manager says "There are no items in Home."

I started to work on some basic tutorials using the sql server business development studio, and everything works fine. I can create reports, which derive data from the AdventureWorks db properly.

Can anyone tell me the adequate steps to fix the SSMSE connection problem and the webinterface view problem?

Here are some additional informations:

I use WinXP SP2, which makes the IIS version 5.1

SQL server is 2005 express with advanced features

and i installed the management toolkit, and the AdventureWorks db.

Installation history is as follows:

.NET framework 2.0 + VS2005 professional edition was installed

1. installed ss2005express+advanced features, on a named instance. worked fine. I did not install the SSMSE at this point, as i knew it is included in the toolkit too.
2. configured the reporting services through the "reporting services configuration" tool. worked fine.
3. installed the management tool kit. worked fine.
4. installed the AdventureWorks db. installed, but was not attached automaticaly to the database engine.
5. attached the AdventureWorks db to the database engine manually. worked fine, can be viewed and accessed properly.

So there I am. I have no clue what went wrong.

A last hint that makes me think is this: In the SSCM the sql server an the sql server reporting services have different instance ids (MSSQL.1 and MSSQL.2 respectively).

Thanks in advance for your solutions and hints, that is - for your time :-)
art

View 7 Replies View Related

Cannot Connect To Sql Express Via ASP.NET After I Attached And Detached My Db To Sql Management Studio

Jun 6, 2006

Hello everybody,

I have an ASP.NET 2.0 website running on a windows server 2003 - sql express management studio installed. Today I had to make some changes in my database, add some columns, and so on...

So I put the app_offline.htm into the root of the web application, so the IIS unloaded the application domain, attached it in the sql management studio, made the changes I had to do and detached the db. Ok - then I removed the app_offline.html from the root of the application and looked at my internet explorer telling me that the user NT_network... cannot login...

What did I do wrong? I attached it, detached it, and at once something went wrong...

I tried everything, at least I copied the whole application to another directory and.... It worked fine again!

So, can anybody help me, I don`t know what I did wrong or rather how to make changes in my sql express for the future, not having trouble with any security issues...

regards

Simon

View 5 Replies View Related

Cannot Connect Remotely To SQLExpress Via SQL Server Management Studio Express

Oct 31, 2007

Hi all, I'm having a little trouble connecting to a SQLExpress instance on a remote domain using SQL Server Management Studio Express.I've read that by default the program is set up locally only, so have edited the Surface Area Configuration. It only gives me the option to edit 'Services and Connections' on the localhost, but have edited the Remote Connections to use TCP/IP and Named Pipes. In the Management Studio, I enter the server name, and login credentials. On the Connection Properties tab I changed the network protocol to TCP/IP though everytime I attempt to connect I get the following error message: Any help would be greatly appreciated. Rich

View 4 Replies View Related

SQL SERVER 2005 Issue, Cannot Connect Using Management Studio Express

Aug 1, 2007

I am unable to connect to my database on a VPS server using server management studio express. I am able to ping the server. can connect to a local database but i have the same issue as others

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

have set the server so that it will allow remote connections and reset the server just to make sure that it has been implemented.

when i use osql in command prompt to make a test connection it tells me this

[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

on this forum it says to perform a ping and and an a ping a- to my server which does work.

Have been working on this for 3 days and can't figure it out.
Even had a guy in New Zealand who is usually my messiah of SQL and he can't figure it out so I'll be impressed if someone knows the answer.

I will buy a crate of beer for the person who solves this for me as this problem is costing me money! Maybe even 2 if done by end of tomorrow 6pm GMT!

If you don't want the beers, i will be more than happy to give a virtual pat on the back. :-)

If you need any more info, i will be watching this thread like a hawk so i'll happily answer any questions that you may have if i can.

Thanks in advance

View 3 Replies View Related

Unable To Connect To SQL Server 2000 Thru SQl Express Management Studio

Apr 11, 2007

I am trying to connect to another computer in my local network which has Windows XP installed. It has SQL server 2000. I get an error message 'Time out period elapsed' when i try to connect to SQL server 2000 thru SQL Server Management Studio Express' Please guide.

View 4 Replies View Related

SQL Sever 2005 Management Studio - Connect As Different Windows User

Jun 22, 2007

I want to connect to a SQL server from my workstation using the application in the Subject, but I need to connect as a different Windows user. Basically, I login to my workstation with my "Joe User" account, but for servers I used my "Joe Admin" account for security purposes. However, the Management console autofills in my workstation username when I select "Windows authentication" for the connection, and grays out the username/password fields so that I cannot specify another set of credentials.

Is there a way to change this behavior? Otherwise I will need to termserv into a server using my administrative account, install the management software there, and then begin the process. That is a lot of unecessary overhead that I would like to avoid.

Thank You,

John G

View 4 Replies View Related