Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





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>
<!--
[HttpCompileException]: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs(19): error CS0246: The type or namespace name 'Site' could not be found (are you missing a using directive or an assembly reference?)
   at System.Web.Compilation.AssemblyBuilder.Compile()
   at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()
   at System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories, Boolean isDirectoryAllowed)
   at System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories)
   at System.Web.Compilation.BuildManager.CompileCodeDirectories()
   at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled()
   at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)
[HttpException]: c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportserver55a9c3a52dd8b450App_Code.7gago72k.0.cs(19): error CS0246: The type or namespace name 'Site' could not be found (are you missing a using directive or an assembly reference?)
   at System.Web.HttpRuntime.FirstRequestInit(HttpContext context)
   at System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context)
   at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--. (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 Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
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 !   View Related
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 !   View Related
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 !   View Related
Can't Connect To Reporting Services Using Microsoft SQL Server Management Studio
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 Replies !   View Related
Cannot Connect To &&"Reporting Services&&" Using Microsoft Sql Server Management Studio.
Hi,

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

<!--

[HttpCompileException]: (0): 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. '

at System.Web.Compilation.AssemblyBuilder.Compile()

at System.Web.Compilation.BuildProvidersCompiler.PerformBuild()

at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp)

at System.Web.Compilation.BuildManager.CompileGlobalAsax()

at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled()

at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)

[HttpException]: (0): 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. '

at System.Web.HttpRuntime.FirstRequestInit(HttpContext context)

at System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context)

at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)

-->

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

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

BUTTONS:

OK

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

View Replies !   View Related
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 !   View Related
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 !   View Related
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 !   View Related
Cannot Connect From Management Studio When Using TCP
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 Replies !   View Related
Can't Connect Through Management Studio Only
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 Replies !   View Related
Unable To Connect To SQL Management Studio
 

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 Replies !   View Related
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 !   View Related
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 !   View Related
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 !   View Related
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 !   View Related
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 !   View Related
Local Management Studio Cannot Connect To Remote IS
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 Replies !   View Related
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 !   View Related
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 !   View Related
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 !   View Related
Can't Connect To Report Server Via Management Studio
Hi,

View Replies !   View Related
Can't Connect To Report Service SQL Management Studio
 

Hi All,
 
I have a problem with connection to Report Service using SQL Management Studio

I specified:
ServerName: MyMachineName
Authentication: Windows Authentication
 
and have got:
 
TITLE: Connect to Server
------------------------------
Cannot connect to SSH.
------------------------------
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------


 
I did try to connect via IIS using URLs: http:\localhost
eport, http:\localhost
eportservice....
but without success.
 
Should I use "Basic Authentication" If so what is default login/password ?
 
Please point me a way to work around this issue.
 
Thanks,
Sergiy

View Replies !   View Related
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 !   View Related
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 !   View Related
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 !   View Related
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 !   View Related
Cannot Connect To Sql Express Via ASP.NET After I Attached And Detached My Db To Sql Management Studio
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 Replies !   View Related
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 !   View Related
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 !   View Related
SQL Sever 2005 Management Studio - Connect As Different Windows User
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 Replies !   View Related
Unable To Connect To SQL Server 2000 Thru SQl Express Management Studio
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 Replies !   View Related
MS Management Studio And Intergration Services
Windows Server 2003 x64 SQL 2005...when I open managment studio and try to open intergration services I can see the local machine that I want to connect to however, I get an error when trying to connect...it says that I need to register a library but doesn't list anything about which library...I have logged into the server as the local admin and am part of a domain w/ my ID added to the admin group and cannot connect w/ either...I can connect to the DB and edit etc under sa...have given the proper accesses to the DB but still cannot connect to the intergration services...Any clues?  I am trying to schedule jobs to run against the database...or if there is another way to schedule these w/o going through this that would be great as well.
 
Thanks in advance,
HJM

View Replies !   View Related
SQL Management Studio And Reporting Serivces Server
Hi,

I have watched Geoff Snowmans webcasts where he connects to the Reporting Services server. Is this option not available in the express edition?

"Database Engine" is the only registered server available.

I have tried right clicking on registered servers ->New->Server Registration but this bring up the "New Server Registration" form where the server type is "Database Engine" and the combo box is disabled.

Thanks for replies

 

 

View Replies !   View Related
Cannot Connect To SQL Report Server Through Web As Well As Management Studio (Http:503 Error Service Unavailable.)
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 Replies !   View Related
Adding Integration Services Node In Server Management Studio
Hi,

View Replies !   View Related
SQL Express Advanced Services Installed On SQL Standard With SQL Management Studio
We've seen two instances of situations where installing SQL Advanced Services SP2 onto a server which already has SQL Server Standard with Management Studio cause network connections to fail.  Uninstalling Express Management Studio restored the network connections.  I'm not talking about the connection to SQL, but the connection between the station and the server.

 

A big question is why the MSI that installs Management Studio doesn't check the environment to see what is already installed.

 

It seems like the SQL Express MSI, when installed in silent mode, is like a bull that just puts various components onto the computer.

 

We are dealing with an unsophisticated market and no matter what you tell them as far as not installing if they already have SQL installed, they don't read instructions.

 

Has anyone seen network connections go away after installing SQL Express on computers that already had some other version of SQL?

 

Thanks,

Pat

 

View Replies !   View Related
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 !   View Related
How To Schedule Integration Services Package(SSIS) 2005 Using Management Studio?or Is There Any Other Way For The Same?
Have anyone  successfully accomplished scheduling integration services package using management studio? or is there any other way to do this?

i am scheduling the package to run from SQL SERVER Management Studio using SQL Server Agent,but it is not working.Help is appreciated.

View Replies !   View Related
64 Bit Install Problems - Management Studio Expr &&amp; Advanced Services &&amp; Toolkit
Hi folks
 
I have a 64 bit Vista Home Premium PC SP1.
 
I downloaded and attempted to install the 64 bit version of SQL Express and I then got an error message to do with the ASP.NET Version registration requirement.
 
I then noticed a similar problem somebody else had & they solved it by doing the install/download as part of the Visual web Developer Expr installation - so I did the same.  It seemed to work without any problems.
 
I had previously downloaded the 64 bit Management Studio Expr file, so after installing SQL server I attempted to install the management Studio program.  Anyhow after starting the install program, I discovered that the instructions were either in Japanese or Chinese.
 
On the download page for SQL Server Express http://www.microsoft.com/express/sql/download/default.aspx,   Under section 3 on the RHS it talks about Advanced Services & the Toolkit.  Presumably, those downloads are for the 32 bit version, so is it possible to get a 64 bit version of Reporting Services & full-text search & the toolkit?
 
Anyway, if somebody could give me a bit of a clue I would really appreciate it.
 
Kind regards
 
Ross

View Replies !   View Related
Am I Right In Using BI Studio To Run Reporting Services ?
Hi,

This is a basic question but I'd be grateful for any suggestions because I just can't get started.

I installed Reporting Services from  a CD-ROM.

When I go to all Programs, I find an entry for BI Development Studio but when I run it, it describes itself as Visual Studio on the top left.

I can create basic Reports OK, but when I try to create Charts, following Brian Larson's book, I find myself looking for things that sound basic, but I can't find them. An example is Report Designer, whereas I have a Report Wizard.

Then I can find a 'Chart' under Report Items, but I can't find out what to do with it - I tried dragging-and-dropping it, double-clicking it and so on, but nothing worked.

I am sure I am doing something basic wrong but I can't figure out what it is.

I'd appreciate any advice !

Barry

 

 

 

.

 

 

  

 

 

View Replies !   View Related
Security Rights Needed To Start And Stop Services From SQL Server Management Studio
Hello everyone.

I have a question about granting enough rights to allow a non admin user to start and stop a sql server service via the SQL Server Management Studio by right clicking on the server node.

 

I have changed the acl's of the SQL Server service security and gave the user rights to start and stop the service. This does allow them to connect remotly to the server using computer manager and they successifully start and stop the service. But, in SQL Server Management Studio the option still does not show up, unless he is a admin of the server.

 

Does anyone know what other security settings I need to address for the start and stop to show up when I right click on the server node?

Thanks for any help

View Replies !   View Related
Reporting Services Section Is Not Showing Under Application Management
Hi,

I installed Reporting Services Add-in for Sharepoint 2007, on my Server where i have both Sharepoint 2007 and SQL Server 2005 and report Server are installed, i already installed SQL Server SP2, but in SharePoint 3.0 Central Administration under Application Management Reporting Services section is not Showing.

 

Please let me know if anybody has the got the same issue and fix it.

 

Thanks

Ahsan

View Replies !   View Related
Reporting Services With Visual Studio
Do I need to load Visual Studio 2005 or Visual Studio 2005.NET to work with the .rdl reports. I have VS 2005 loaded and I can't access my reports I created before my hard drive died...

 

View Replies !   View Related
Cant Connect To Reporting Services
our IT guy installed Reporting Services on our test server, but the problem is that I cannot not connect to it. It says the the report services instance coundt not be found. Am I correct in saying that report services needs its own instance?? Cause when I put it on my local computer I gave it its own instance and theres no problems there

View Replies !   View Related
Cannot Connect To Reporting Services
I'm getting the following message when I try to connect to Reporting Services. 'The Report Services Instance could not be found'.
 
Report Services was installed separetly from the Database engine install. I see a reference in the documentation that Reporting Services has to be installed concurrntly with the Database engine. There are also to reporting databases installed. Assuming that this is the problem, is there a way to create the databases and connect to them without uninstalling and reinstalling the components. I've tried using the Database setup in the Reporting Services Configuration utility without success.
 
Thans,
Tom

View Replies !   View Related
Cannot Connect To Reporting Services Using IE Or S
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 !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved