I'm having trouble getting a new linked server to work.
Server Mfr is 2005 Dev (sp1) and is the 'local' server.
Server Krypton is 2000 EE sp3 and is the target server I need to link to and
query.
I have a valid Windows login on both systems and I'm in the sysadmin group
on both servers.
After linking the servers using Mgt Studio, I ran this:
EXEC sp_addlinkedsrvlogin @.rmtsrvname = 'KRYPTON', @.useself = 'true'
When I try running this query:
SELECT * FROM OPENQUERY(KRYPTON, 'SELECT * FROM CRICUST WHERE CustName =
''Acme''')
I get these errors:
OLE DB provider "SQLNCLI" for linked server "KRYPTON" returned message
"Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18452, Level 14, State 1, Line 0
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
Can you see what I'm missing?
Thanks!
djNo login credentials are being passed to the remote server.
Did you set everything up needed for delegation?
Have you tried with a SQL Login to see if the basics parts
(without the delegation issues) are working? For the linked
server, Just map all users to a valid SQL login on the
remote server to see if that works.
-Sue
On Thu, 10 Aug 2006 06:40:02 -0700, dj
<dj@.discussions.microsoft.com> wrote:
>I'm having trouble getting a new linked server to work.
>Server Mfr is 2005 Dev (sp1) and is the 'local' server.
>Server Krypton is 2000 EE sp3 and is the target server I need to link to an
d
>query.
>I have a valid Windows login on both systems and I'm in the sysadmin group
>on both servers.
>After linking the servers using Mgt Studio, I ran this:
>EXEC sp_addlinkedsrvlogin @.rmtsrvname = 'KRYPTON', @.useself = 'true'
>When I try running this query:
>SELECT * FROM OPENQUERY(KRYPTON, 'SELECT * FROM CRICUST WHERE CustName =
>''Acme''')
>I get these errors:
>OLE DB provider "SQLNCLI" for linked server "KRYPTON" returned message
>"Communication link failure".
>Msg 10054, Level 16, State 1, Line 0
>TCP Provider: An existing connection was forcibly closed by the remote host
.
>Msg 18452, Level 14, State 1, Line 0
>Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>Server connection.
>Can you see what I'm missing?
>Thanks!
>dj|||Hi Sue -
We're not on AD, so I believe delegation isn't an option.
If I'm using Windows authentication and my account exits on both machines,
do I still need to pass credentials? I thought the 'useself' parameter took
care of that.
Or am I just very confused (quite possibly)?
Thanks.
"Sue Hoegemeier" wrote:
> No login credentials are being passed to the remote server.
> Did you set everything up needed for delegation?
> Have you tried with a SQL Login to see if the basics parts
> (without the delegation issues) are working? For the linked
> server, Just map all users to a valid SQL login on the
> remote server to see if that works.
> -Sue
> On Thu, 10 Aug 2006 06:40:02 -0700, dj
> <dj@.discussions.microsoft.com> wrote:
>
>|||You are correct that if you aren't using AD, you can't use
delegation. Delegation will pass your authentication
information from one server to another. useself just says to
use the current login for authentication against the remote
server but doesn't really manage any of the passing of
credentials or how that will work (or not work).
Try using a SQL login for the security mappings to the
remote linked server.
-Sue
On Thu, 10 Aug 2006 11:07:01 -0700, dj
<dj@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Sue -
>We're not on AD, so I believe delegation isn't an option.
>If I'm using Windows authentication and my account exits on both machines,
>do I still need to pass credentials? I thought the 'useself' parameter too
k
>care of that.
>Or am I just very confused (quite possibly)?
>Thanks.
>"Sue Hoegemeier" wrote:
>
Showing posts with label local. Show all posts
Showing posts with label local. Show all posts
Tuesday, March 27, 2012
Monday, March 19, 2012
Can't deploy from local machine
Can anyone help me. I work in a workgroup environment as opposed to domain
controlled. The minute I do anything with reporting services or analysis
services that is between machines I get problems.
I can't deploy to SSAS or SSRS from my machine unless I log into my machine
with a username and account that is the same as the machine being deployed
to. How do I tell BIDS what credentials to use.
Can anyone give me an overview of how credentials are passed in a non domain
environment.On Sep 25, 2:47 pm, "Fresno Bob" <nos...@.nospam.com> wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
This article is off topic; however, gives a general explanation
similar to your scenario. http://msdn2.microsoft.com/en-us/library/ms252507(VS.80).aspx
It seems that this is more of an OS security level/authentication
issue. As far as I know, you may not be able to control the BIDS
credentials. At a Report Server level, you should be able to change
credentials once the report is deployed in the Report Mgr. You might
try looking in the ReportProjectName.rptproj.user file to see if you
can possibly modify something there. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||SSAS Requires Windows Authentication to work and does not accept SQL
Authentication. If you are in a workgroup the only way to get your scenario
to work is to create identical local accounts on both machines. When I say
identical I mean has the same name and password. Since you are not in a
domain there isn't a way for the remote server to validate your credentials
and will therefore always get a user of "null".
--
SQL Server Developer Support Engineer
"Fresno Bob" wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
>
>
controlled. The minute I do anything with reporting services or analysis
services that is between machines I get problems.
I can't deploy to SSAS or SSRS from my machine unless I log into my machine
with a username and account that is the same as the machine being deployed
to. How do I tell BIDS what credentials to use.
Can anyone give me an overview of how credentials are passed in a non domain
environment.On Sep 25, 2:47 pm, "Fresno Bob" <nos...@.nospam.com> wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
This article is off topic; however, gives a general explanation
similar to your scenario. http://msdn2.microsoft.com/en-us/library/ms252507(VS.80).aspx
It seems that this is more of an OS security level/authentication
issue. As far as I know, you may not be able to control the BIDS
credentials. At a Report Server level, you should be able to change
credentials once the report is deployed in the Report Mgr. You might
try looking in the ReportProjectName.rptproj.user file to see if you
can possibly modify something there. Sorry that I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||SSAS Requires Windows Authentication to work and does not accept SQL
Authentication. If you are in a workgroup the only way to get your scenario
to work is to create identical local accounts on both machines. When I say
identical I mean has the same name and password. Since you are not in a
domain there isn't a way for the remote server to validate your credentials
and will therefore always get a user of "null".
--
SQL Server Developer Support Engineer
"Fresno Bob" wrote:
> Can anyone help me. I work in a workgroup environment as opposed to domain
> controlled. The minute I do anything with reporting services or analysis
> services that is between machines I get problems.
> I can't deploy to SSAS or SSRS from my machine unless I log into my machine
> with a username and account that is the same as the machine being deployed
> to. How do I tell BIDS what credentials to use.
> Can anyone give me an overview of how credentials are passed in a non domain
> environment.
>
>
Saturday, February 25, 2012
Can't create a ODBC DSN to a remote MSDE instance
Hello,
I need to create an ODBC DNS that points to a remote MSDE instance, but I
can only get it to work if I turn Windows Firewall off. Both the local and
remote machines are WinXP SP2 and have SQL2000 and MSDE, same domain and I
can login as the same person on each machine.
On the remote machine I've enabled TCP/IP and the default port, and I've
added that port to the firewall, but when I try to add a DSN (on the local
machine) in the ODBC control panel it says
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
I've looked at the instance via Enterprise Manager and my domain login has
admin privs, and can connect a DSN to the SQL2000 server on that machine.
Stumped.
Suggestions?
Keith
hi Keith,
Keith wrote:
> Hello,
> I need to create an ODBC DNS that points to a remote MSDE instance,
> but I can only get it to work if I turn Windows Firewall off. Both
> the local and remote machines are WinXP SP2 and have SQL2000 and
> MSDE, same domain and I can login as the same person on each machine.
> On the remote machine I've enabled TCP/IP and the default port, and
> I've added that port to the firewall, but when I try to add a DSN (on
> the local machine) in the ODBC control panel it says
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
> exist or access denied.
> I've looked at the instance via Enterprise Manager and my domain
> login has admin privs, and can connect a DSN to the SQL2000 server on
> that machine.
did you define an exception on the server's firewall on the MSDE used TCP/IP
port or on the service itself?
http://support.microsoft.com/default.aspx?kbid=841249
http://support.microsoft.com/default.aspx?scid=kb;[LN];841251
http://support.microsoft.com/default.aspx?scid=kb;[LN];884012 (Win2003)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||>
> did you define an exception on the server's firewall on the MSDE used
> TCP/IP port or on the service itself?
> http://support.microsoft.com/default.aspx?kbid=841249
> http://support.microsoft.com/default.aspx?scid=kb;[LN];841251
> http://support.microsoft.com/default.aspx?scid=kb;[LN];884012 (Win2003)
Well, after some reboots and a walk around the block it works now.
I finally got it to work either with firewall port exception, or a service
exception, but neither way seemed very consistent. Making changes to the
firewall while it is running just doesn't seem to work that well; perhaps I
wasn't waiting long enough for the changes to propagate or I just need to
stop/start the firewall after changing something.
And I suspect that some of the changes that don't "require" rebooting really
do.
Anyway, thanks for the quick response and support links.
Keith
I need to create an ODBC DNS that points to a remote MSDE instance, but I
can only get it to work if I turn Windows Firewall off. Both the local and
remote machines are WinXP SP2 and have SQL2000 and MSDE, same domain and I
can login as the same person on each machine.
On the remote machine I've enabled TCP/IP and the default port, and I've
added that port to the firewall, but when I try to add a DSN (on the local
machine) in the ODBC control panel it says
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.
I've looked at the instance via Enterprise Manager and my domain login has
admin privs, and can connect a DSN to the SQL2000 server on that machine.
Stumped.
Suggestions?
Keith
hi Keith,
Keith wrote:
> Hello,
> I need to create an ODBC DNS that points to a remote MSDE instance,
> but I can only get it to work if I turn Windows Firewall off. Both
> the local and remote machines are WinXP SP2 and have SQL2000 and
> MSDE, same domain and I can login as the same person on each machine.
> On the remote machine I've enabled TCP/IP and the default port, and
> I've added that port to the firewall, but when I try to add a DSN (on
> the local machine) in the ODBC control panel it says
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
> exist or access denied.
> I've looked at the instance via Enterprise Manager and my domain
> login has admin privs, and can connect a DSN to the SQL2000 server on
> that machine.
did you define an exception on the server's firewall on the MSDE used TCP/IP
port or on the service itself?
http://support.microsoft.com/default.aspx?kbid=841249
http://support.microsoft.com/default.aspx?scid=kb;[LN];841251
http://support.microsoft.com/default.aspx?scid=kb;[LN];884012 (Win2003)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||>
> did you define an exception on the server's firewall on the MSDE used
> TCP/IP port or on the service itself?
> http://support.microsoft.com/default.aspx?kbid=841249
> http://support.microsoft.com/default.aspx?scid=kb;[LN];841251
> http://support.microsoft.com/default.aspx?scid=kb;[LN];884012 (Win2003)
Well, after some reboots and a walk around the block it works now.
I finally got it to work either with firewall port exception, or a service
exception, but neither way seemed very consistent. Making changes to the
firewall while it is running just doesn't seem to work that well; perhaps I
wasn't waiting long enough for the changes to propagate or I just need to
stop/start the firewall after changing something.
And I suspect that some of the changes that don't "require" rebooting really
do.
Anyway, thanks for the quick response and support links.
Keith
Cant copy database, strange error
I'm trying to copy a database from my web host to local Sql Server 2005 instance using the Copy Database wizard. I get this error:
An exception occurred while executing a Transact-SQL statement or batch.
Server user 'celestine' is not a valid user id database 'db2'.
However, 'db2' isn't the database I was trying to copy! I am trying to copy db1, but this error is complaining about db2, which is in fact somebody else's database that I don't have a login for. Why am I getting an error about db2 when I'm not trying to do anything with db2?
I can however export the tables from db1 just fine using Export. But then I have to go back and generate script to re-create the stored procs, views, etc., so it is rather tedious to do it that way.
This may be possible. For example if there is a view in db1 which references a table in db2, and the celestine login does not have access to db2, you may encounter this error.
So to avoid such issue, you can move/copy database by taking a full backup of the source database and then restore it on the destination server.
|||Good idea but -- No, this is not the case. This is a shared hosting situation, the 2nd database is owned by someone else, I have absolutely no access to it at all. There is no relationship whatsoever between the databases.
I can't do a backup/restore either because I don't have access to the remote filesystem.
|||
Urgh...that's really a trouble. Then check whether your login has sufficient permissions to perform copy database task:
Required permissions
For the Copy Database Wizard to work, you must have the correct permissions, depending on how you are copying the database, as follows:
For the Detach and Attach Method, you must be a member of thesysadmin fixed server role on the both source and destination servers.|||Right. But a) I do have correct permissions for both source/destination for the database I'm trying to copy, and b) The error is not pertaining to the database I want to copy. The error mentions a different database, that I have zero permissions for, that I will never have permissions for, that I don't want permissions for. I am trying to copy db1 and the error says "you don't have permissions for db2". Why is it even checking anything for db2?
Friday, February 24, 2012
can't connect with OLEDB, but ODBC works
I have a local database that I'm having trouble selecting as a source in
DTS. I can connect just fine using "mymachinename", but if I try to use
(local) or an alias in Client Network Utility, I get the error:
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (Connect()).]
SQL Server does not exist or access denied.
I noticed that if I changed the driver to ODBC, then it works fine. Also, I
can connect using any name in Query Analyzer. However, I need to use OLEDB
and also the alias. I have Windows XP Pro and SQL 2000 Developer Edition w/
SP3. Here's all the different tests I have done with OLEDB:
Server Authentication Result
-- -- --
mymachinename Windows OK
mymachinename SQL login OK
myalias Windows SQL Server does not exist or access denied.
myalias SQL login SQL Server does not exist or access denied.
(local) Windows SQL Server does not exist or access denied.
(local) SQL login SQL Server does not exist or access denied.Can you make an OLE DB connection through a UDL? To create a UDL, just
right-click on your desktop and choose to create a new document. Name it
anything you want. Then rename the extension to .udl. Then double-click on
it. Choose your driver and other connection properties and test it. If it
works from there then most likely OLE DB is fine.
(local) is using shared memory and an alias is using whatever protocol is
defined in cliconfg.exe for that alias. When you get a successful
connection which protocol are you using? For a successful connection you
can do:
SELECT network_library, * from master..sysprocesses where spid = @.@.spid to
see your actual protocol.
It may be that the difference isn't odbc vs. ole db but rather tcp vs.
shared memory vs. named pipes. To force connectivity with each type of
protocol:
for tcp use: tcp:mymachinename
for named pipes use: np:mymachinename
for shared memory use: lpc: mymachinename
You can find more troubleshooting steps in:
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
DTS. I can connect just fine using "mymachinename", but if I try to use
(local) or an alias in Client Network Utility, I get the error:
Error Source : Microsoft OLE DB Provider for SQL Server
Error Description : [DBNETLIB][ConnectionOpen (Connect()).]
SQL Server does not exist or access denied.
I noticed that if I changed the driver to ODBC, then it works fine. Also, I
can connect using any name in Query Analyzer. However, I need to use OLEDB
and also the alias. I have Windows XP Pro and SQL 2000 Developer Edition w/
SP3. Here's all the different tests I have done with OLEDB:
Server Authentication Result
-- -- --
mymachinename Windows OK
mymachinename SQL login OK
myalias Windows SQL Server does not exist or access denied.
myalias SQL login SQL Server does not exist or access denied.
(local) Windows SQL Server does not exist or access denied.
(local) SQL login SQL Server does not exist or access denied.Can you make an OLE DB connection through a UDL? To create a UDL, just
right-click on your desktop and choose to create a new document. Name it
anything you want. Then rename the extension to .udl. Then double-click on
it. Choose your driver and other connection properties and test it. If it
works from there then most likely OLE DB is fine.
(local) is using shared memory and an alias is using whatever protocol is
defined in cliconfg.exe for that alias. When you get a successful
connection which protocol are you using? For a successful connection you
can do:
SELECT network_library, * from master..sysprocesses where spid = @.@.spid to
see your actual protocol.
It may be that the difference isn't odbc vs. ole db but rather tcp vs.
shared memory vs. named pipes. To force connectivity with each type of
protocol:
for tcp use: tcp:mymachinename
for named pipes use: np:mymachinename
for shared memory use: lpc: mymachinename
You can find more troubleshooting steps in:
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10
Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>
|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I
|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there[vbcol=seagreen]
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove
>Once
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10
Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>
|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I
|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there[vbcol=seagreen]
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove
>Once
>
>
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
--
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> --
> >From: "sck10" <sck10@.online.nospam>
> >Hello,
> >
> >I had SS2K running on my local machine (everything worked). Then I
> >installed SS2005 and was able to connect the server running locally.
Once
> I
> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
> >create a new registration, I get the error that I can't connect to the
> >server. Any help with this would be greatly appreciated.
> >
> >--
> >Thanks in advance,
> >
> >sck10|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>> Hello,
>> It seems issues in client tools. You may want to check "sql server
>browser"
>> service is started. Also, please remove/reinstall SQL tools via
Add/Remove
>> programs to test the situation.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> --
>> >From: "sck10" <sck10@.online.nospam>
>> >Hello,
>> >
>> >I had SS2K running on my local machine (everything worked). Then I
>> >installed SS2005 and was able to connect the server running locally.
>Once
>> I
>> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>> >create a new registration, I get the error that I can't connect to the
>> >server. Any help with this would be greatly appreciated.
>> >
>> >--
>> >Thanks in advance,
>> >
>> >sck10
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
--
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> --
> >From: "sck10" <sck10@.online.nospam>
> >Hello,
> >
> >I had SS2K running on my local machine (everything worked). Then I
> >installed SS2005 and was able to connect the server running locally.
Once
> I
> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
> >create a new registration, I get the error that I can't connect to the
> >server. Any help with this would be greatly appreciated.
> >
> >--
> >Thanks in advance,
> >
> >sck10|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>> Hello,
>> It seems issues in client tools. You may want to check "sql server
>browser"
>> service is started. Also, please remove/reinstall SQL tools via
Add/Remove
>> programs to test the situation.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> --
>> >From: "sck10" <sck10@.online.nospam>
>> >Hello,
>> >
>> >I had SS2K running on my local machine (everything worked). Then I
>> >installed SS2005 and was able to connect the server running locally.
>Once
>> I
>> >uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>> >create a new registration, I get the error that I can't connect to the
>> >server. Any help with this would be greatly appreciated.
>> >
>> >--
>> >Thanks in advance,
>> >
>> >sck10
>
>
Can't connect to SS2005
Hello,
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove[vbcol=seagreen]
>
>Once
>
>
I had SS2K running on my local machine (everything worked). Then I
installed SS2005 and was able to connect the server running locally. Once I
uninstalled SQL Server 2000, I was unable to connect. Even if I try to
create a new registration, I get the error that I can't connect to the
server. Any help with this would be greatly appreciated.
Thanks in advance,
sck10Hello,
It seems issues in client tools. You may want to check "sql server browser"
service is started. Also, please remove/reinstall SQL tools via Add/Remove
programs to test the situation.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>Subject: Can't connect to SS2005
>Date: Wed, 8 Feb 2006 10:05:31 -0600
>Lines: 14
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420451
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello,
>I had SS2K running on my local machine (everything worked). Then I
>installed SS2005 and was able to connect the server running locally. Once
I
>uninstalled SQL Server 2000, I was unable to connect. Even if I try to
>create a new registration, I get the error that I can't connect to the
>server. Any help with this would be greatly appreciated.
>--
>Thanks in advance,
>sck10
>
>|||Hello Peter,
I re-installed SS2005, but I am still unable to create a new registration on
my local machine. I first went to the SQL Server Browser service, but there
were no devices to turn off or on. I then went to the Surface Area
Configurator, but received the following error. I am the administrator for
this machine (Windows XP Pro).
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
--
Thanks in advance,
sck10
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> It seems issues in client tools. You may want to check "sql server
browser"
> service is started. Also, please remove/reinstall SQL tools via Add/Remove
> programs to test the situation.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
[vbcol=seagreen]
> --
Once[vbcol=seagreen]
> I|||Hello,
It seems there are permission issues for admin users on this machine,
please try the following command to reset permission on this machine to
test.
secedit /configure /cfg %windir%\repair\secsetup.inf /db secsetup.sdb
/verbose
Also, you may want to log on a different admin to test.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "sck10" <sck10@.online.nospam>
>References: <#e309lMLGHA.2392@.TK2MSFTNGP09.phx.gbl>
<5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Can't connect to SS2005
>Date: Thu, 9 Feb 2006 08:57:01 -0600
>Lines: 56
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
>Message-ID: <OivfWkYLGHA.3060@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: 11.202.185.135.in-addr.arpa 135.185.202.11
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:420554
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Hello Peter,
>I re-installed SS2005, but I am still unable to create a new registration
on
>my local machine. I first went to the SQL Server Browser service, but
there
>were no devices to turn off or on. I then went to the Surface Area
>Configurator, but received the following error. I am the administrator for
>this machine (Windows XP Pro).
>TITLE: Surface Area Configuration
>--
>No SQL Server 2005 components were found on the specified computer. Either
>no components are installed, or you are not an administrator on this
>computer. (SQLSAC)
>--
>Thanks in advance,
>sck10
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:5Li58ESLGHA.3504@.TK2MSFTNGXA01.phx.gbl...
>browser"
Add/Remove[vbcol=seagreen]
>
>Once
>
>
Sunday, February 19, 2012
Can't connect to sql server 2005 - SSL
Hi,
I Receive this message when I try to connect sql server 2005 express...
Cannot connect to LOCAL\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: SSL Provider, error: 0 -
La cha?ne de certificat a été fournie par une autorité qui n'est pas
approuvée.) (.Net SqlClient Data Provider)
I don't have a SSL certificate and i don't want to use it.
Do you have any idea how I can fix it ?
Thanks in advance.
Erik
Forget it...
I found the solution. I ran REGEDIT and remove the
HKLM/SOFTWARE/MICROSOFT/MSSQLServer/CLIENT/...
... and there were a key about SSL (I already forgot the name).
After that, SQL SERVER ran without error.
;o)
I Receive this message when I try to connect sql server 2005 express...
Cannot connect to LOCAL\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: SSL Provider, error: 0 -
La cha?ne de certificat a été fournie par une autorité qui n'est pas
approuvée.) (.Net SqlClient Data Provider)
I don't have a SSL certificate and i don't want to use it.
Do you have any idea how I can fix it ?
Thanks in advance.
Erik
Forget it...
I found the solution. I ran REGEDIT and remove the
HKLM/SOFTWARE/MICROSOFT/MSSQLServer/CLIENT/...
... and there were a key about SSL (I already forgot the name).
After that, SQL SERVER ran without error.
;o)
Can't connect to sql server 2005 - SSL
Hi,
I Receive this message when I try to connect sql server 2005 express...
Cannot connect to LOCAL\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: SSL Provider, error: 0 -
La cha?ne de certificat a été fournie par une autorité qui n'est pas
approuvée.) (.Net SqlClient Data Provider)
I don't have a SSL certificate and i don't want to use it.
Do you have any idea how I can fix it '
Thanks in advance.
ErikForget it...
I found the solution. I ran REGEDIT and remove the
HKLM/SOFTWARE/MICROSOFT/MSSQLServer/CLIENT/...
... and there were a key about SSL (I already forgot the name).
After that, SQL SERVER ran without error.
;o)
I Receive this message when I try to connect sql server 2005 express...
Cannot connect to LOCAL\SQLEXPRESS.
===================================
A connection was successfully established with the server, but then an error
occurred during the pre-login handshake. (provider: SSL Provider, error: 0 -
La cha?ne de certificat a été fournie par une autorité qui n'est pas
approuvée.) (.Net SqlClient Data Provider)
I don't have a SSL certificate and i don't want to use it.
Do you have any idea how I can fix it '
Thanks in advance.
ErikForget it...
I found the solution. I ran REGEDIT and remove the
HKLM/SOFTWARE/MICROSOFT/MSSQLServer/CLIENT/...
... and there were a key about SSL (I already forgot the name).
After that, SQL SERVER ran without error.
;o)
Thursday, February 16, 2012
Can't Connect to SQL 2005 Using Remote Desktop and Local Administr
I installed SQL 2005 Standard on Windows 2003 R2, and when I connect to the
server (no firewall involved) using Remote Desktop, I can't login to
Management Studio using the local administrator account. However, I can log
in using the domain administrator account. The local administrator account i
s
not locked out. I get the following error when trying to access Management
Studio using the local admin. account:
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) (.Net SqlClient Data Provider)
Any ideas?***UPDATE***
Actually, it has nothing to do with remote connectivity. I tried to log in
to Management Studio locally as the local administrator, and it still
wouldn't let me and gave the same error. As mentioned previously, the domain
admin. works.
Thanks.
"Marks70" wrote:
> I installed SQL 2005 Standard on Windows 2003 R2, and when I connect to th
e
> server (no firewall involved) using Remote Desktop, I can't login to
> Management Studio using the local administrator account. However, I can lo
g
> in using the domain administrator account. The local administrator account
is
> not locked out. I get the following error when trying to access Management
> Studio using the local admin. account:
> 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 t
o
> SQL Server) (.Net SqlClient Data Provider)
> Any ideas?
server (no firewall involved) using Remote Desktop, I can't login to
Management Studio using the local administrator account. However, I can log
in using the domain administrator account. The local administrator account i
s
not locked out. I get the following error when trying to access Management
Studio using the local admin. account:
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) (.Net SqlClient Data Provider)
Any ideas?***UPDATE***
Actually, it has nothing to do with remote connectivity. I tried to log in
to Management Studio locally as the local administrator, and it still
wouldn't let me and gave the same error. As mentioned previously, the domain
admin. works.
Thanks.
"Marks70" wrote:
> I installed SQL 2005 Standard on Windows 2003 R2, and when I connect to th
e
> server (no firewall involved) using Remote Desktop, I can't login to
> Management Studio using the local administrator account. However, I can lo
g
> in using the domain administrator account. The local administrator account
is
> not locked out. I get the following error when trying to access Management
> Studio using the local admin. account:
> 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 t
o
> SQL Server) (.Net SqlClient Data Provider)
> Any ideas?
Can't connect to server using server management studio
Hi,
For some reason I can't connect to a (remote) SQL server using SQL server
management studio (2005) from my local SQL 2005 Server. I can connect from
numerous other PCs/Servers in my site except this one. The local SQL Server
is running Windows 2003 R2.
It will accept the username (sa) and password and just hang there. It then
pops up the error:
"is Busy
Microsoft SQL Server Management Studio is waiting for an internal operation
to complete."
Then after a while it will fail with the error:
"An exception occurred while executing a transact-sql statement or batch.
Additional information:-
A transport level error has occured when receiving results from the server"
I have checked the network setup and there are definately no firewall or
routing issues (after all you can log on - if you get the password wrong it
tells you), plus several other PCs/Servers at this site can access the
server with no problems at all. There is no firewall on the local server.
Can anyone shed any light on this? Any help much appreciated.
Thanks in advance,
-H
Can you connect to the SQL instance from that client machine at all, I mean,
if you try a different tool such as osql.exe? That should help narrow the
scope of the problem.
Linchi
"Hooopla" wrote:
> Hi,
> For some reason I can't connect to a (remote) SQL server using SQL server
> management studio (2005) from my local SQL 2005 Server. I can connect from
> numerous other PCs/Servers in my site except this one. The local SQL Server
> is running Windows 2003 R2.
> It will accept the username (sa) and password and just hang there. It then
> pops up the error:
> "is Busy
> Microsoft SQL Server Management Studio is waiting for an internal operation
> to complete."
> Then after a while it will fail with the error:
> "An exception occurred while executing a transact-sql statement or batch.
> Additional information:-
> A transport level error has occured when receiving results from the server"
> I have checked the network setup and there are definately no firewall or
> routing issues (after all you can log on - if you get the password wrong it
> tells you), plus several other PCs/Servers at this site can access the
> server with no problems at all. There is no firewall on the local server.
> Can anyone shed any light on this? Any help much appreciated.
> Thanks in advance,
> -H
>
>
|||I'm afraid osql times out aswell. I'm also trying to use a third party
package and that has the same problem
-H
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
|||FYI I can remote desktop successfully to the remote server.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
For some reason I can't connect to a (remote) SQL server using SQL server
management studio (2005) from my local SQL 2005 Server. I can connect from
numerous other PCs/Servers in my site except this one. The local SQL Server
is running Windows 2003 R2.
It will accept the username (sa) and password and just hang there. It then
pops up the error:
"is Busy
Microsoft SQL Server Management Studio is waiting for an internal operation
to complete."
Then after a while it will fail with the error:
"An exception occurred while executing a transact-sql statement or batch.
Additional information:-
A transport level error has occured when receiving results from the server"
I have checked the network setup and there are definately no firewall or
routing issues (after all you can log on - if you get the password wrong it
tells you), plus several other PCs/Servers at this site can access the
server with no problems at all. There is no firewall on the local server.
Can anyone shed any light on this? Any help much appreciated.
Thanks in advance,
-H
Can you connect to the SQL instance from that client machine at all, I mean,
if you try a different tool such as osql.exe? That should help narrow the
scope of the problem.
Linchi
"Hooopla" wrote:
> Hi,
> For some reason I can't connect to a (remote) SQL server using SQL server
> management studio (2005) from my local SQL 2005 Server. I can connect from
> numerous other PCs/Servers in my site except this one. The local SQL Server
> is running Windows 2003 R2.
> It will accept the username (sa) and password and just hang there. It then
> pops up the error:
> "is Busy
> Microsoft SQL Server Management Studio is waiting for an internal operation
> to complete."
> Then after a while it will fail with the error:
> "An exception occurred while executing a transact-sql statement or batch.
> Additional information:-
> A transport level error has occured when receiving results from the server"
> I have checked the network setup and there are definately no firewall or
> routing issues (after all you can log on - if you get the password wrong it
> tells you), plus several other PCs/Servers at this site can access the
> server with no problems at all. There is no firewall on the local server.
> Can anyone shed any light on this? Any help much appreciated.
> Thanks in advance,
> -H
>
>
|||I'm afraid osql times out aswell. I'm also trying to use a third party
package and that has the same problem
-H
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
|||FYI I can remote desktop successfully to the remote server.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
Can't connect to server using server management studio
Hi,
For some reason I can't connect to a (remote) SQL server using SQL server
management studio (2005) from my local SQL 2005 Server. I can connect from
numerous other PCs/Servers in my site except this one. The local SQL Server
is running Windows 2003 R2.
It will accept the username (sa) and password and just hang there. It then
pops up the error:
"is Busy
Microsoft SQL Server Management Studio is waiting for an internal operation
to complete."
Then after a while it will fail with the error:
"An exception occurred while executing a transact-sql statement or batch.
Additional information:-
A transport level error has occured when receiving results from the server"
I have checked the network setup and there are definately no firewall or
routing issues (after all you can log on - if you get the password wrong it
tells you), plus several other PCs/Servers at this site can access the
server with no problems at all. There is no firewall on the local server.
Can anyone shed any light on this? Any help much appreciated.
Thanks in advance,
-HCan you connect to the SQL instance from that client machine at all, I mean,
if you try a different tool such as osql.exe? That should help narrow the
scope of the problem.
Linchi
"Hooopla" wrote:
> Hi,
> For some reason I can't connect to a (remote) SQL server using SQL server
> management studio (2005) from my local SQL 2005 Server. I can connect from
> numerous other PCs/Servers in my site except this one. The local SQL Serve
r
> is running Windows 2003 R2.
> It will accept the username (sa) and password and just hang there. It then
> pops up the error:
> "is Busy
> Microsoft SQL Server Management Studio is waiting for an internal operatio
n
> to complete."
> Then after a while it will fail with the error:
> "An exception occurred while executing a transact-sql statement or batch.
> Additional information:-
> A transport level error has occured when receiving results from the server
"
> I have checked the network setup and there are definately no firewall or
> routing issues (after all you can log on - if you get the password wrong i
t
> tells you), plus several other PCs/Servers at this site can access the
> server with no problems at all. There is no firewall on the local server.
> Can anyone shed any light on this? Any help much appreciated.
> Thanks in advance,
> -H
>
>|||I'm afraid osql times out aswell. I'm also trying to use a third party
package and that has the same problem
-H
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
>|||FYI I can remote desktop successfully to the remote server.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
>
For some reason I can't connect to a (remote) SQL server using SQL server
management studio (2005) from my local SQL 2005 Server. I can connect from
numerous other PCs/Servers in my site except this one. The local SQL Server
is running Windows 2003 R2.
It will accept the username (sa) and password and just hang there. It then
pops up the error:
"is Busy
Microsoft SQL Server Management Studio is waiting for an internal operation
to complete."
Then after a while it will fail with the error:
"An exception occurred while executing a transact-sql statement or batch.
Additional information:-
A transport level error has occured when receiving results from the server"
I have checked the network setup and there are definately no firewall or
routing issues (after all you can log on - if you get the password wrong it
tells you), plus several other PCs/Servers at this site can access the
server with no problems at all. There is no firewall on the local server.
Can anyone shed any light on this? Any help much appreciated.
Thanks in advance,
-HCan you connect to the SQL instance from that client machine at all, I mean,
if you try a different tool such as osql.exe? That should help narrow the
scope of the problem.
Linchi
"Hooopla" wrote:
> Hi,
> For some reason I can't connect to a (remote) SQL server using SQL server
> management studio (2005) from my local SQL 2005 Server. I can connect from
> numerous other PCs/Servers in my site except this one. The local SQL Serve
r
> is running Windows 2003 R2.
> It will accept the username (sa) and password and just hang there. It then
> pops up the error:
> "is Busy
> Microsoft SQL Server Management Studio is waiting for an internal operatio
n
> to complete."
> Then after a while it will fail with the error:
> "An exception occurred while executing a transact-sql statement or batch.
> Additional information:-
> A transport level error has occured when receiving results from the server
"
> I have checked the network setup and there are definately no firewall or
> routing issues (after all you can log on - if you get the password wrong i
t
> tells you), plus several other PCs/Servers at this site can access the
> server with no problems at all. There is no firewall on the local server.
> Can anyone shed any light on this? Any help much appreciated.
> Thanks in advance,
> -H
>
>|||I'm afraid osql times out aswell. I'm also trying to use a third party
package and that has the same problem
-H
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
>|||FYI I can remote desktop successfully to the remote server.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
>
Tuesday, February 14, 2012
Can't connect to Report Server via Management Studio
Hi,
I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.
I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.
I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:
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 hints would be appreciated...
Thanks,
/vijayan
http://servername/reportserver
or
servername/instance
The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.
Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.
Run out of ideas to try...
/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.|||
You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.
|||Vijayan
Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.
Thanks
Brad
|||Vijayan -I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?
Jim|||
I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.
Roshan.
|||Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?
I firstly, can you provide the directory to which the reportserver virtual directory is pointing
Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.
Lastly, if there is an ASP.Net tab, what is the value set to?
If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?
If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?
Thanks!
-Lukasz
|||Hi Lukasz,
Following are the information requested.
ReportServer virtual directory is pointing to :
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Mappings:
Application extensions: There are no entries
Wildcard application maps:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Options:
Enable session state : Ticked
Enable buffering : Ticked
Default ASP Language : VBScript
There is no ASP.Net tab.
Best Regards,
Roshan.
|||Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0
If it does not exist, run the command:
aspnet_regiis.exe -i
from the folder:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:
rskeymgmt.exe
-Lukasz
|||Hi Lukas,
Thanks for the reply.
I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.
Thanks,
Roshan.
|||So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?
That is really unusual.
When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?
-Lukasz
|||Has anyone found an answer to this issue? I am having the same problem.|||Can you provide more info on exactly how you reproduce the problem?
Can you provide answers to my post above?
-Lukasz
Can't connect to Report Server via Management Studio
Hi,
I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.
I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.
I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:
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 hints would be appreciated...
Thanks,
/vijayan
http://servername/reportserver
or
servername/instance
The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.
Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.
Run out of ideas to try...
/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.|||
You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.
|||Vijayan
Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.
Thanks
Brad
|||Vijayan -I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?
Jim|||
I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.
Roshan.
|||Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?
I firstly, can you provide the directory to which the reportserver virtual directory is pointing
Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.
Lastly, if there is an ASP.Net tab, what is the value set to?
If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?
If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?
Thanks!
-Lukasz
|||Hi Lukasz,
Following are the information requested.
ReportServer virtual directory is pointing to :
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Mappings:
Application extensions: There are no entries
Wildcard application maps:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Options:
Enable session state : Ticked
Enable buffering : Ticked
Default ASP Language : VBScript
There is no ASP.Net tab.
Best Regards,
Roshan.
|||Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0
If it does not exist, run the command:
aspnet_regiis.exe -i
from the folder:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:
rskeymgmt.exe
-Lukasz
|||Hi Lukas,
Thanks for the reply.
I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.
Thanks,
Roshan.
|||So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?
That is really unusual.
When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?
-Lukasz
|||Has anyone found an answer to this issue? I am having the same problem.|||Can you provide more info on exactly how you reproduce the problem?
Can you provide answers to my post above?
-Lukasz
Can't connect to Report Server via Management Studio
Hi,
I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.
I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.
I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:
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 hints would be appreciated...
Thanks,
/vijayan
http://servername/reportserver
or
servername/instance
The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.
Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.
Run out of ideas to try...
/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.
|||
You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.
|||Vijayan
Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.
Thanks
Brad
|||Vijayan -I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?
Jim|||
I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.
Roshan.
|||Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?
I firstly, can you provide the directory to which the reportserver virtual directory is pointing
Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.
Lastly, if there is an ASP.Net tab, what is the value set to?
If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?
If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?
Thanks!
-Lukasz
|||Hi Lukasz,
Following are the information requested.
ReportServer virtual directory is pointing to :
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Mappings:
Application extensions: There are no entries
Wildcard application maps:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Options:
Enable session state : Ticked
Enable buffering : Ticked
Default ASP Language : VBScript
There is no ASP.Net tab.
Best Regards,
Roshan.
|||
Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0
If it does not exist, run the command:
aspnet_regiis.exe -i
from the folder:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:
rskeymgmt.exe
-Lukasz
|||Hi Lukas,
Thanks for the reply.
I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.
Thanks,
Roshan.
|||
So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?
That is really unusual.
When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?
-Lukasz
|||Has anyone found an answer to this issue? I am having the same problem.|||Can you provide more info on exactly how you reproduce the problem?
Can you provide answers to my post above?
-Lukasz
Can't connect to Report Server via Management Studio
Hi,
I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.
I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.
I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:
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 hints would be appreciated...
Thanks,
/vijayan
http://servername/reportserver
or
servername/instance
The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.
Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.
Run out of ideas to try...
/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.
|||
You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.
|||Vijayan
Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.
Thanks
Brad
|||Vijayan -I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?
Jim|||
I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.
Roshan.
|||Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?
I firstly, can you provide the directory to which the reportserver virtual directory is pointing
Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.
Lastly, if there is an ASP.Net tab, what is the value set to?
If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?
If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?
Thanks!
-Lukasz
|||Hi Lukasz,
Following are the information requested.
ReportServer virtual directory is pointing to :
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Mappings:
Application extensions: There are no entries
Wildcard application maps:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Options:
Enable session state : Ticked
Enable buffering : Ticked
Default ASP Language : VBScript
There is no ASP.Net tab.
Best Regards,
Roshan.
|||
Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0
If it does not exist, run the command:
aspnet_regiis.exe -i
from the folder:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:
rskeymgmt.exe
-Lukasz
|||Hi Lukas,
Thanks for the reply.
I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.
Thanks,
Roshan.
|||
So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?
That is really unusual.
When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?
-Lukasz
|||Has anyone found an answer to this issue? I am having the same problem.|||Can you provide more info on exactly how you reproduce the problem?
Can you provide answers to my post above?
-Lukasz
Can't connect to Report Server via Management Studio
Hi,
I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.
I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.
I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:
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 hints would be appreciated...
Thanks,
/vijayan
http://servername/reportserver
or
servername/instance
The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.
Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.
Run out of ideas to try...
/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.
|||
You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.
|||Vijayan
Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.
Thanks
Brad
|||Vijayan -I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?
Jim|||
I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.
Roshan.
|||Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?
I firstly, can you provide the directory to which the reportserver virtual directory is pointing
Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.
Lastly, if there is an ASP.Net tab, what is the value set to?
If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?
If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?
Thanks!
-Lukasz
|||Hi Lukasz,
Following are the information requested.
ReportServer virtual directory is pointing to :
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Mappings:
Application extensions: There are no entries
Wildcard application maps:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Options:
Enable session state : Ticked
Enable buffering : Ticked
Default ASP Language : VBScript
There is no ASP.Net tab.
Best Regards,
Roshan.
|||
Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0
If it does not exist, run the command:
aspnet_regiis.exe -i
from the folder:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:
rskeymgmt.exe
-Lukasz
|||Hi Lukas,
Thanks for the reply.
I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.
Thanks,
Roshan.
|||
So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?
That is really unusual.
When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?
-Lukasz
|||Has anyone found an answer to this issue? I am having the same problem.|||Can you provide more info on exactly how you reproduce the problem?
Can you provide answers to my post above?
-Lukasz
Can't connect to Report Server via Management Studio
Hi,
I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.
I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.
I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:
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 hints would be appreciated...
Thanks,
/vijayan
http://servername/reportserver
or
servername/instance
The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.
Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.
Run out of ideas to try...
/v|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.|||
You don't have any other version of the .NET Framework on the client machine, do you? Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.
|||Vijayan
Did you manage to solve this problem? I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.
Thanks
Brad
|||Vijayan -I am also having the same problem. and I have no idea on how to trouble shoot it? Can you let us know if you made any progress on the resolution of the issue?
Jim|||
I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.
Roshan.
|||Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory?
I firstly, can you provide the directory to which the reportserver virtual directory is pointing
Secondly, what are the script mappings for the virtual directory? You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.
Lastly, if there is an ASP.Net tab, what is the value set to?
If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName?
If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab?
Thanks!
-Lukasz
|||Hi Lukasz,
Following are the information requested.
ReportServer virtual directory is pointing to :
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Mappings:
Application extensions: There are no entries
Wildcard application maps:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Options:
Enable session state : Ticked
Enable buffering : Ticked
Default ASP Language : VBScript
There is no ASP.Net tab.
Best Regards,
Roshan.
|||Do you know if you installed .Net Framework v2 before you had IIS installed? If you did or if the following registry key is not present, you'll need to register ASP.NET.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0
If it does not exist, run the command:
aspnet_regiis.exe -i
from the folder:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:
rskeymgmt.exe
-Lukasz
|||Hi Lukas,
Thanks for the reply.
I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.
Thanks,
Roshan.
|||So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work?
That is really unusual.
When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer?
-Lukasz
|||Has anyone found an answer to this issue? I am having the same problem.|||Can you provide more info on exactly how you reproduce the problem?
Can you provide answers to my post above?
-Lukasz
Cant Connect to remote server, my app works in local only??
Hello,
i've developed a website using VB.NET, and SQL SERVER 2K, in my dev environment works properly (SQL Server and WEB SERVER are in the same machine).
When i put everything in the target machine, where the webserver is but not the sql, i get the following error:
Sql SErver does not exist or access denied
i've developed a website using VB.NET, and SQL SERVER 2K, in my dev environment works properly (SQL Server and WEB SERVER are in the same machine).
When i put everything in the target machine, where the webserver is but not the sql, i get the following error:
Sql SErver does not exist or access denied
I've tried so many ways to do this, ODBC, ADO.NET, OLEDB....and everything ends in the same error.
Also if i try to connect with ODBC (from odbc manager) it seems to work (test connection succesfull), but in asp.net nothing works.
I've tried to access the server with:
INSTANCE_NAME
\SERVER_NAME\INSTANCE_NAME
IP,PORT
I think (they are checking this), that the auth mode is set to MIXED MODE.
Any idea to save my life?? ;)
Thanks pplYour reference to the server in your ADO connection string should be:
ipaddressofserver\instancename (i.e., 206.152.125.6\instance1 )
If you are using SQL Authenticiation, which you should, then you need to reference the {uid} and {password} properties.
I would be willing to bet that your SQL Installation is set the Mixed Mode.
HTH
Subscribe to:
Posts (Atom)