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

Can't Connect To SQL Reporting Services Through IIS And SQL Server Management Studio
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 Replies !

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

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 Replies !

Can't Connect Management Studio To Reporting Services
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 Replies !

Error Trying To Connect To Reporting Services Using SQL Management Studio
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 Replies !

REPORTING SERVICE CONFIGURATION FOR MICROSOFT SQL SERVER MANAGEMENT STUDIO EXPRESS
i'm a new beginner in microsoft sql server management studio. Can anybody guide me how to use it and give me tutorial about developing database using mcrosoft sql and how to make reporting services

View Replies !

Microsoft SQL Server 2005 Management Studio - Opening SQL-File From Explorer Does Not Connect Automaticly To Server/database
hello,

I have a question about opening files in the Microsoft SQL Server 2005 Management Studio.

In the old Query Analyzer from SQL 2000 I can open SQL Files via drag & drop (from explorer to QA) or open it with a double click in the explorer. Then the Files opened, if I had actual a connection to a server / database (QA is stared with one file and has a connection to Server/Datebase), with this connection.

Now in Microsoft SQL Server 2005 Management Studio I'll be asked everytime for Server and have to get the database from the database list - it does not connect automaticly to server/database, that is actual connected (I have opened a file with the connection and a connected database in the object explorer).

Someone do not have this problem - but we found no option to set it up.

Any ideas?

thanks &
best regards,
Christian Kiedels

View Replies !

Reporting Services 2005 And SQL Server Management Studio Connection Error
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 Replies !

Query That Works In Management Studio, Fails In Reporting Services
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 Replies !

Problem Opening Reporting Services In SQL 2005 Management Studio
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 Replies !

Problem Connect To Reporting Services Via Mgmt Studio
I'm using SQL 2005 Management Studio and am having a problemconnecting to Reporting Services. I get the following error when Iattempt to connect. To ReportingServices running on the same clientthat I am connecting from. Does anyone know what is going on?Cannot connect to <server name>Additional Information:The request failed with HTP status 502: Bad Gateway.(Microsoft.SqlServer.Management.UI.RSClient)

View Replies !

Can't Access Reporting Services In Management Studio Or Web Interface Using Windows Integrated Security
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 Replies !

Report Viewer Issue In Visual Studio 2005 Beta 2. For Microsoft Reporting Services
Hi

View Replies !

Microsoft SQL Server Management Studio
I was looking for Microsoft SQL Server Management Studio but downladed Microsoft SQL Server Management Studio EXPRESS.
the express version doesn't have the SQL server agent. I read that the express doesnt support SQL server agent. Is there any add-on or service pack available for this.
I am trying to find "SQL server Management studio". Any idea where I can download it?

View Replies !

Microsoft SQL Server Management Studio
i try to open database table using Microsoft SQL Server Management Studio i got the follwing error msg i don't know what the problem

===================================
Object reference not set to an instance of an object. (SQLEditors)
------------------------------Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.OpenTableNode.CreateDesigner(IDTDocToolFactoryProvider factoryProvider, IVsDataConnection dataConnection) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner() at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open() at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con) at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

View Replies !

Trigger - Microsoft SQL Server Management Studio
Hi,
How to create Trigger in "SQL SERVER 2005 - Microsoft SQL Server Management Studio"? This is my 1st interaction with SQL SERVER 2005.

Thanks,
Rahul Jha

View Replies !

Query Abt Microsoft SQL Server Management Studio

Hi all,
I am Vaibhav.I am using Microsoft SQL Server Management Studio 9.00.1399.00 on my machine , which have Windows 2000 Professional OS installed. Now I am upgrading My ystem to Windows Vista OS.
And I am not getting whether Microsoft SQL Server Management Studio 9.00.1399.00 will support Windows Vista? or I have to go for Higher version available for Microsoft SQL Server Management studio ?
Please asist me on same.

Thanks,

Vaibhav Tare

View Replies !

Microsoft SQL Server Management Studio Express

Is Microsoft SQL Server Management Studio Express (sql 2005) compatible with Sql Server 2000 databases?
I'm using Windows Vista and the sql 2000 Enterprise Manager is not fully compatible with Vista...long not responding messages.
Can i use the client version of Slq 2005?

Regards

View Replies !

Microsoft SQL Server Management Studio Express Problem
Microsoft SQL Server Management Studio ExpressI have restored the database into it with 100tables and stored procedures.I have also created the new database in it.But,i don't know how to add the existing database in to Visual Studio.Net 2005 .I m using ASP.Net.Where are the database stored ?? I don't want to create the new database,.Can anyone pls tell me ....

View Replies !

Is It Possible To Create A DTS Package Using Microsoft Sql Server Management Studio
Is it possible to create a DTS package using microsoft sql server management studio. if yes? How can i do it.

Any help is appreciated.

Regards,

Karen

View Replies !

Reinstalling Microsoft Server Management Studio Express

I was having some trouble with the DTS Wizard and so I thought I'd just reinstall the whole MSSM. I used remove programs, rebooted my Vista computer and am trying to reinstall the Server Express Toolkit. It tells me that MSSM already exists on my computer (which it doesn't).

The actual screen reads:

Existing components
The following components that you chose to install are already installed on the machine.
Grayed out -- Workstation components and development tools 9.2.3042.00

How do I reinstall MSSM now? It's gone from my computer.

Thanks!

View Replies !

How To Get Started On Microsoft SQL Server Management Studio Express
Hi,

Was trying to open AdventureWorks when i got this error: "There is no editor available "C: Program Flies.....AdventureWorksDW_Log.LDF'
Make sure the application for the file type(.LDF) is installed.
How can this error be corrected? I also have some error on mdf not installed.May i know how should be the initally steps to be done inorder for me to view this database.
And if i do have a database from microsoft access, what are the steps that i need to do inorder to get it export to Microsoft SQL Server Management Studio Express. Please advise as i really new to it. Thanks!

View Replies !

Can't View .mdf Files In Microsoft SQL Server Management Studio Express
I am unable to view any .mdf files in Microsoft SQL Server Management Studio Express, even though it is looking for an .mdf extension. Why is this? Is this a limitation of the Express version?More specifically i want to view the aspnetdb.mdf file that is created with each web application.Any thoughts? Thanks.Jason

View Replies !

Microsoft SQL Server Management Studio Express Version To Use For SQL Compact
Hello,

i don't know if it was mentioned before, but i solved the issue that Microsoft SQL Server Management Studio Express won't show the option to create/modify a sql compact database by installing not this Version:

Microsoft SQL Server Management Studio Express
Date: 19.04.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en

but this one:

SQL Server Management Studio Express Service Pack 2 €“ CTP-Version
Date: 19.12.2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=ccbda432-8ecf-4c82-bdef-b575eaf07f55&DisplayLang=en

hope this helps.

Nihat

P.S. i'm curious if anybody else had the same issue, caused of using the wrong Version of SSMSe?

View Replies !

Importing Tables To Microsoft SQL Server Management Studio Express
Hello,

I'm trying to import some tables from another sql server to my laptop. I just downloaded Microsoft SQL Server Management Studio Express and i'm not sure how to import things. Could anyone help me with that?

Thanks a bunch

j

View Replies !

Microsoft SQL Server Management Studio Express (SSMSE) Upgrade
Hi

Apologies for this question

I have just found out i/we need to upgrade to the full version of this management tool to make use of SSRS for a new CRM we are putting in place, The CRM company tells me we can just install the tool from our SQL 2005 disk.

Im wondering what the best way to go about this is? i would guess we just un-install the express version install the full version of the management tool and reconnect to the database. unless im missing anything?

thanks

View Replies !

Problem Copying Database With Microsoft SQl Server Management Studio
I am trying to copy a database from the server on my web host(crystaltech) to my new local install of MS SQL Server 2005 Enterprise (trial version).

I go to Tasks>Copy Database which opens the wizard. When I get to the select database screen I get this error:

Server user 'username' is not a valid user in database '123foo'

(123foo is the first database of all those on the server)

I need have it look only at my database which I have permissions for to copy it. How do I do this?

I tried copying the tables the other way(import data) but it dropped all my identities and primary keys which is a pain to recreate. Is there a way to copy tables from one server to another without losing primary keys and identity fields?

Thanks for any help!

View Replies !

Problems Downloading Microsoft SQL Server Management Studio Express
I everybody,

I'm trying to download Microsoft SQL Server Management Studio Express from

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

However, the download never finishs.

If I try to download using a download manager it stops after 98% (the segment that stops is the first segment).
If I try to download without a download manager it stops after 1% (456Kb).

What can I do?

Is there an alternate place where I can download the file?

Thanks,

Nadav

View Replies !

Can't Connect To SQL Server Management Studio Through VPN
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 Replies !

Cannot Connect Via C# But Can Via Server Management Studio
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 Replies !

Error In Microsoft Sql Server Management Studio Trying To Modify Tables Or Columns
I get the error below when trying to modify a table or colum with MSSMS. I can expad out the tree and look at the columns, but I can't change them, view the data in them, or create new ones.
__________________________________________________________________________________________________________________________________
TITLE: Microsoft SQL Server Management Studio
------------------------------
Class does not support aggregation (or class object is remote) (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION)) (Microsoft.SqlServer.SqlTools.VSIntegration)
I resintallelled .NET Framework, recommended from another post. I am using .NET 3.5 BETA Frame work, ans SQL Server 2005 V 9.00.139.00

View Replies !

Using Microsoft SQL Server Management Studio Express To Export/copy Database?
How does one export/copy a database using Microsoft SQL Server
Management Studio Express? At this time, I have an existing
database that I can access and run queries against. However, I
cannot connect to it via Visual Wed Developer 2005 Express. At
this time, I'm getting the following error message with the existing
database:

Login failed for user 'bigide2_gims2'. The user is not associated with a trusted SQL Server Connection.

Next, I'm running everything locally. If anyone can assist, it would be greatly appreciated and thanks in advance.

-Conrad

View Replies !

How Can I Create A New Login In Microsoft SQL Server Management Studio Express 9.00.1399.00?
How can I create a new login in Microsoft SQL Server Management Studio Express 9.00.1399.00?
I hope to create a new login in Microsoft SQL Server Management Studio Express for SQL 2005 database,I select SQL Server authentication item in New Login window, then I click Ok button, but I get the error information:
An exception occurred while executing a Transact-SQL statement or batch.The Must_CHANGE option is not supported by this version of microsoft Window, Error: 15195
Does it mean that I can not create new login in Microsoft SQL Server Management Studio Express 9.00.1399.00?

View Replies !

How Can I Remove Expiration Date From Microsoft SQL Server Management Studio (Standard Ed)
Recently we upgrade the SQL Server 2005 from Evaluation Ed to Standard Ed.
It was like a full installation since we already had installe the SP1, we had to uninstall it completely.
If we enter the following query:
SELECT SERVERPROPERTY('productversion') as ProductVersion,
        SERVERPROPERTY ('productlevel') as ProductLevel,
        SERVERPROPERTY ('edition') as ProductEdition
it shows that we have the Std Ed (not the Evaliation Ed.):

9.00.2047.00    SP1    Standard Edition

However, since a few days ago the Management Studio showed the following message: Microsoft SQL Server Management Studio (expires in 4 days).

Any help would be appreciated

View Replies !

Installing Microsoft SQL Server Management Studio Express Broke My Asp.net Databases
Morning,

I installed the managerment stuid on my machine and now none of my database connections seem to work any more. I keep getting the attached error. Before I installed the studio the system worked fine, I could connect to the database and everything was fine. Does the studio change any permission stuff? I cannot seem to get it to work again at all now, I added in aspnet as a login inside the studio and it still won't let me connect to the database. I cannot find *any* logs anywhere that might be helpful in what it is doing or see any way to debug the connection to find out what the problem is. When I look at the permissions inside of the studio it shows me that the connections should all be fine.

I checked and remote and local connections are setup, although it is only doing local connections anyway since this is a asp.net web server page.

Any idea what the problem is here? This is very frustrating and annoying :( Since I didn't change anything and now nothing I will do gets it to work. I even tried to uninstall the management tool and it still doesn't work.
Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFYASPNET'.

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: Cannot open user default database. Login failed.
Login failed for user 'GREENANDFLUFFYASPNET'.

View Replies !

Cannot Connect To Sql Server Management Studio - SSL Issue?
We are working with a need to implement SSL and I used the IIS resource kits selfssl.exe tool to create a certification to test somethings on localhost. This worked well and I logged off, went home, logged back on from home via vnc and worked some more. No problems. I then logged off and called it a night. I did not uninstall the personall ssl certificate. At midnight, my machine reboots and defrags. Just including all the 'variables' I can think of. This morning I came into work and noticed that I could not successfully connect to the website. Then I noticed that I was not connecting to Sql Server. I got the error: A connection was successfully established with the server, but then an
error occurred during the pre-login handshake. (provider: Shared Memory
Provider, error: 0 - No process is on the other end of the pipe.) Okay. So I went to the event viewer and there was a new event, beginning after my reboot at midnight: A fatal error occurred when attempting to access the SSL server credential private key. The error code returned from the cryptographic module is 0x80090016. So I ran the certmgr.msc tool and removed the certificate from my personal folder. I still could not connect. Not after a reboot, not after stopping and restarting SQL Server, and not after removing the cert via IIS and stopping and restarting IIS.So I decided I would go to Management Studio and test the connection there. I could not connect via Management Studio! If anyone has an experience to lend here, I would be appreciative. Thank you.

View Replies !

Cannot Connect To Database In Server Management Studio
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 Replies !

Help! Getting Errors When Trying To Connect To SQL Server Management Studio
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 Replies !

Cannot Connect To Database In Server Management Studio
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 Replies !

Cannot Connect To Database In Server Management Studio
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 Replies !

SQL Server Management Studio 2005 Can't Connect
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 Replies !

Can't Connect To Report Server Via Management Studio
Hi,

View Replies !

Error Connecting To Remote Server Using Microsoft SQL Server Management Studio Express
Dear All,

I am trying to connect to a remote sql server 2005. So I have install the Microsoft SQL Server Management Studio Express. When I try to connect I get the error below.

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53). Can some one please help. I have even port no 1533 on my pc. Thanks.

View Replies !

Cannot Connect To SQL Server Express Edition Using Its Management Studio
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 Replies !

Can I Use SQL 2005 Management Studio To Connect To SQL 2000 Server?
Hi,Can I use SQL 2005 Management studio to connect to SQL 2000 server?

View Replies !

Cannot Connect To Report Server From Management Studio Express

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 Replies !

Can You Connect To An Oracle DB Using MS Sql Server Management Studio Express?
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 Replies !

SQL Compact Edition 3.5 Vs. SQL Server Management Studio 2008, FileNotFoundException Microsoft.SqlServerCe.ManagementUI
Hi,I'm having an exception below when i tried to connect to SQL Server Compact Edition from SQL Server Management Studio (10.0.1075.23 ((SQL_PreRelease).071108-1357 )).I downloaded and installed the SQL Server Compact Edition 3.5 from this link below :http://www.microsoft.com/downloads/details.aspx?FamilyID=38ed2670-a70a-43b3-87f3-7ab67b56cbf2&displaylang=enAnd I downloaded and installed the SQL Server 2008 Development edition from this link below :http://go.microsoft.com/fwlink/?LinkId=104963It seems that the SQL Server 2008 Development edition comes with the these 2 SQL CE below :- Microsoft SQL Server Compact 3.5 SP1 Beta ENU. Product Version: 3.5.5608.0.- Microsoft SQL Server Compact 3.5 SP1 Beta Management Tools ENU. Product Version: 3.5.5608.0I tried to uninstalled these 2 and re-install the SQL Server Compact Edition 3.5 Files, but it didn't help.Currently I'm uninstalling SQL Server 2008 because the command prompt installation instruction page could not be found in the books online, so i'm trying my luck to uninstall SQL Server Compact Edition 3.5 and reinstall the whole SQL Server 2008. The main reason why I was trying to install SQL Server 2008 Developer Edition is only to manage SQL Server Compact 3.5 database file. Since i upgraded the database into 3.5, i was not able to open it anymore using SQL Express 2005 Query Designer in the VS 2008 is just like the sql view query designer which is not as good as sql management studio. I'm reminiscing the good old days with query analyzer Any advice to resolve this issue?
Thanks in advance Steps :1. Choose Database : SQL Server Compact Edition2. Choose Any of the Database file options (New Database or Browse for more)3. Below exception will pop up.See the end of this message for details on invokingjust-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServerCe.ManagementUI, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.File name: 'Microsoft.SqlServerCe.ManagementUI, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) 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) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Utils.LoadAssembly(String assemblyFileName) at Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerCeType.Microsoft.SqlServer.Management.UI.ConnectionDlg.IServerType2.CustomNewDatabaseAction() at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.CheckForNewDatabase() at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.OnSIIndexChange(Object sender, EventArgs e) at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e) at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m) at System.Windows.Forms.ComboBox.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)

View Replies !

Cannot Connect Remotely To SQLExpress Via SQL Server Management Studio Express
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 Replies !

SQL SERVER 2005 Issue, Cannot Connect Using Management Studio Express
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 Replies !