Can't start ReportServer service

Hello

I having problem to start ReportServer service after our Network administrator reboot the reporting server. Getting an error: "Error 1075: The dependency service does not exist or has been marked for deletion."

This is an error message from Event Viewer: "The ReportServer service depends on the following nonexistent service: mssqlserver"

First there are no explicit dependencies, second we have sql server installed on different machine. Any ideas how to fix it? Would appriciate any help.

Is this RS 2005? Early versions of RS2000 had a dependency on SQL Server, but this has not been the case for sometime and never in a released version. Is it possible this was an upgrade from an early 2000 beta?

The best option might be to uninstall RS then reinstall, hooking up to the old DB. Make sure you back up your symmetric key first or you will have to reenter all credentials.

Can't see the SQL Server Express Instance on SQL Browser

Hi All,

I am using SQL Server Express to connect to the network using VPN on a local machine. I have done the following..

a.) Enabled the remote connections for the Express Instance and rebooted the machine.

b.) Connected to the machine with Express Edition locally and can also connect other SQL Server instances from it to verify connectivity.

c.) Yes, SQL Browser Service is running.

d.) Firewall is not turned on, so I do not have to configure any exceptions.

Now here is the big problem: When I browse for SQL Servers on the network the machine does not show up on the list, i.e "macinename\SQLExpress". I had uninstalled and reinstalled the Express edition and rebooted the machine several times with no luck on the SQL Express Instance showing up on the browser list. I even changed the default instance name to "machinename\MACHINE1" on one of the reinstalls. However, I can connect to other SQL Instances from it. But, I cannot connect to it from other machines since its not registered on the network. I have been working on this for the past few days by looking for a solution via this and other forumns. Is there some setting somewhere that I am missing that prevents this instance from not showing up on the browser list. This issue with SQL Express Edition is baffling as well as frustrating and any ideas that can resolve this issue is very much appreciated.

when you say you cant see it on the list, do you mean in the ODBC dialog list? or some other list? if its involves the ODBC dialog, ive had to actually type in the whole machinename \SQLExpress since it didnt show up initially for it to work.|||I am talking about the SQL Server Browser list, that one can see all of the live SQL Server database Instances. Not the dialog list...|||I have several of them that refuse to show up in any browser list. But, I can connect to just about all of them even though they don't show up in the browser list by just typing in the instance name. Is there a particular error that you are getting? Can you give us more detail on your configuration and exactly what steps you are doing?|||

After installing SQL Server Express Edition on a new HP laptop with WIN 2K sp2, I went to see if it was registered on the Network as "machinename/SQLEXPRESS", and what I can see on the Network is just the "machinename", with the instance name missing. So I reinstalled it with a new instance name "machinename/Machine1", and again it was missing the instance name "Machine1", but I can see the machinename. I tried to connect with the instance name only "Machine1" and believe me I have tried it every which way but I always get the infamous error:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)"

Now here is the odd part, I had installed SQL Server Express Edition on a older (1 year) IBM laptop with WIN 2K sp2, about 1 month back and was able to see the complete instance name on the network and can connect just fine. The only difference in these two machines is the age, but they both have the same OS Software installed. I have been pulling my hair in trying to figure out what is going on with SQL Server Express Edition on this new HP laptop with WIN 2K sp2 installed. It just refuses to register itself correctly on the network.

|||I have several that the browser only sees the machine name. That still doesn't mean that is what you use for the connection string. If you are using a default instance of Express Edition, then you still need to connect to machinename\SQLExpress even if browsing only shows you just the machine name. Now, that doesn't mean that you aren't having issues similar to mine on one of my clients which refuses to allow me to connect, we just need to make sure there isn't something else wrong first.|||As I have mentioned before, I tried using "machinename\MACHINE1" as the complete instance name and it throws out the error as I posted before. I can connect other instances from this HP Laptop but cannot connect to it from other machines. Perhaps we are having the same issue. I have been asking our Network Admin, System Admin and Security Admin and they are all puzzled by this SQL Express behavior on this HP laptop. I am wondering if it has anything to do with particular PC machines as the IBM pc works fine, but not the HP, this is just a guess. But I am running out of ideas and my users are running out of patience as I try to find a solution to this big problem....|||

Not sure if this has anything to do with your issue, but you mentioned that you were using Win2000 SP2, that is not a supported platform for SQL 2005, you need to be running SP4. I'm surprised that install didn't block.

Mike

|||

Yes, it looks like you are having exactly the same issue as I'm having on one of my machines. I have everything configured correctly with all of the access configured the way it needs to be. I can quite literally do anything I want to on the client when I'm RDPed into the server including remotely launching applications, remotely stopping start services, etc. The only that that it refuses to do is recognize and connect to the SQL Server Express Edition instance. I'm having problem doing further troubleshooting and opening a support case is rather difficult since the problem machine is in CA and I'm in TX without any direct ability to get hands on with the machine. I thought I had another one exhibiting this behavior, but when I plugged the laptop into my network, it magically started working and it hasn't thrown the error since. Yes, I'm rather baffled. My only saving grace is that I don't have any more hair to pull out at this point. :)

I have several more machines to work through and I'm hoping that I can get at least one of them to exhibit this behavior.

|||

I'm getting a bit closer on my side and now have 2 machines that are having issues. So, I want to try something and see if your results duplicate mine.

Log on to the machine that is having problems using your accouunt. Once it is up and running, go over to another instance and login to the Express instance from the other machine using your Windows credentials. Let me know if that magically makes it work.

|||

Hi Michael,

Nope, I tried as you suggested and I keep getting that same error, from the other machine when I try to connect to the problem machine. However, I can connect from the problem machine to any other SQL Server 2005 instance...Do not know what to do at this point. Perhaps Microsoft needs to help out...I hope they are reading this Message.

|||I am wondering if this issue has anything to do with having 2 NIC cards in a Laptop machine, one for the Local Network and the other for the Wireless Network...That is the only difference I see with the 2 different Laptops I am working with. The IBM machine does not have a Wireless Network NIC and it works...The other newer HP has a Wireless NIC and it does not work..Is Microsoft listening.....|||I can rule that one out. I have machines that connect just fine with multiple NICs and a couple that don't that also have multiple NICs.|||Have you tried opening a support case with Microsoft. I am not sure how this particular Software is supported since it is freely distributed..|||

SQL Server Express Edition is fully supported. Just like you can call in and get support on Internet Explorer.

I found a couple of other things when I was doing additional configuration. Verify that your WINS scopes are set properly. Also verify that the machine is actually getting its IP address correctly registered into DNS. These two items fixed 100% of the connectivity issues that I was having within SQL Server.

Cant See Network Server

Hi, I just installed SQL Server 2005 on Windows Server 2003 (Act as DNS and DHCP server for the network). When I tried to access it from my workstation (Windows XP Pro), using SQL Server Management Studio, theres no list of Network Server available. Anything that I should configure first?

Hi,

is SQL Server Browser started on the server ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Did you enable it for network listening? By default it is not in certain SKUs(IIRC developer and express do not listen by default).|||How to enable network listening? And.. Wheres SQL Server Browser?
Its Enterprise Edition..

|||Use the Surface Area Configuration Tool|||Yay!!! Thanks guys..

Cant register local instance of SQL Server on local server PLUS

I have two servers running SQL Server on the same network and I am
receiving errors registering the various instances as follows:

SERVER1 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()

SERVER1 trying to register Server2's default instance (by netname, ip
address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER
FROM ANYWHERE PROVIDED THAT YOU HAVE PERMISSION(S)

SERVER2 tried to register the local instance (by netname, ip address
and local)
ERROR Msg: ssl security error -connectionopen(secdoclienthandshake)

SERVER2 trying to register Server1's default instance (by netname, ip
address and local)
ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
Connect()

Note: SERVER2's default instance was registered locally before, but I
wanted to change the alias name so I unregistered it and tried to
register it with the new alias. I only change the alias name not the
underlying information which was previously registered. That is when I
started to receive the errors. ALSO I DON'T KNOW IF THIS MATTERS, BUT
D01 WAS CLONED FROM D02 BECAUSE OF A DISK FAILURE. I DID HOWEVER RUN
THE NEWSID UTILITY.

Any Ideas?(war_wheelan@.yahoo.com) writes:
> SERVER1 tried to register the local instance (by netname, ip address
> and local)
> ERROR Msg: SQL Server does not exist or access denied (ConnectionOpen |
> Connect()

Have you ensured that is running?

> SERVER1 trying to register Server2's default instance (by netname, ip
> address and local) COMPLETES SUCESSFULLY (THIS INSTANCE CAN BE REGISTER
> FROM ANYWHERE PROVIDED THAT YOU HAVE PERMISSION(S)
> SERVER2 tried to register the local instance (by netname, ip address
> and local)
> ERROR Msg: ssl security error -connectionopen(secdoclienthandshake)

Could http://support.microsoft.com/kb/322144/EN-US/ apply?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland,

Thanks for the pointer to the Microsoft article. In the future, I will
look on the Microsoft's web site more throughly.

Answer: Someone in my organization must of inadvertently enable
encryption for the client without my knowledge.

Thanks.

Can't print from SSRS on Citrix

Hi,
We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
click the print icon in SSRS, I get an Internet Explorer Security Warning
asking if I want to install Microsoft SQL Server. When I click "Don't
Install" I get the message, "Unable to load client print control." It seems
like there's a component that needs to be installed to enable printing from
SSRS, but I don't know what it is. Can anyone point me in the right
direction here?
--
Thanks,
JeffI think the IE security Warning refers to installing SSRS's report
preview/print activeX control, not the SQL Server itself. When you use IE to
open a report and try to print it the first time, that preview/print ActiveX
control must be downloaded to the computer where IE run and installed. So,
you need to go ahead to allow the installation once for all.
"Jeff Stroope" <JeffStroope@.discussions.microsoft.com> wrote in message
news:6C241737-15F5-4A8C-9FD5-724D650105DC@.microsoft.com...
> Hi,
> We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
> click the print icon in SSRS, I get an Internet Explorer Security Warning
> asking if I want to install Microsoft SQL Server. When I click "Don't
> Install" I get the message, "Unable to load client print control." It
> seems
> like there's a component that needs to be installed to enable printing
> from
> SSRS, but I don't know what it is. Can anyone point me in the right
> direction here?
> --
> Thanks,
> Jeff|||Thanks Norman!
--
Thanks,
Jeff
"Norman Yuan" wrote:
> I think the IE security Warning refers to installing SSRS's report
> preview/print activeX control, not the SQL Server itself. When you use IE to
> open a report and try to print it the first time, that preview/print ActiveX
> control must be downloaded to the computer where IE run and installed. So,
> you need to go ahead to allow the installation once for all.
> "Jeff Stroope" <JeffStroope@.discussions.microsoft.com> wrote in message
> news:6C241737-15F5-4A8C-9FD5-724D650105DC@.microsoft.com...
> > Hi,
> >
> > We have SSRS 2005 running on SQL Server 2000 on a Citrix network. When I
> > click the print icon in SSRS, I get an Internet Explorer Security Warning
> > asking if I want to install Microsoft SQL Server. When I click "Don't
> > Install" I get the message, "Unable to load client print control." It
> > seems
> > like there's a component that needs to be installed to enable printing
> > from
> > SSRS, but I don't know what it is. Can anyone point me in the right
> > direction here?
> > --
> > Thanks,
> >
> > Jeff
>
>

Can't login with windows user

Hi
Please what do you mean by map the network (network mapping) ?Mapping a network drive is to create a namesake, say "J" drive which is
actually pointing to a share across your network, like \\shared1\sqlfiles.
To do so, open Windows explorer, go to the Tools menu, you'll find "Map
network drive" as the 1st option. That option gives you the drive 'letter'
you want to choose, as well as the "folder" which is the network share. You
will of course have to be using a domain account, and that should have
necessary permissions to access that shared folder.
Hope that helps!
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Cant log into remote server

Hello everyone, I am having issues with connecting to

another database on the same network. I am creating a management system for the

company that I work for and I am currently working on the database side of it

and learning as I go along which means that I am fairly new but I think I have

got the basic concepts.

The system will have multiple databases at different locations.

The idea is for all the databases to have all the same data so that the system

can keep operating if the internet goes down.

The plan is to use the merge replication function within sql 2005 (currently working with the enterprise trial); I think I need to do

publications and subscriptions on all the databases to have the dataflow in 2

directions. In order to do this I need to setup users. I have created 1 user

with the same credentials to the 2 machines that the databases are running

from.

I have linked the users to sql with the correct privileges. I can connect to

one remote database, but when I try to connect to the other I get this message

"Login failed for user 'NEAL-LAPTOP\Guest'. (.Net SqlClient Data

Provider)" other information with this error "Server Name:

NEAL-LAPTOP Error Number: 18456 Severity: 14 State: 1 Line Number: 65536"

keep in mind that the user in not "Guest" and I am logged in as the

correct user.

I would appreciate if anyone can help me out with this

Hi,

you will have to disable the simple file sharing on the server machine. If activated incoming connections will be "authenticated" as the Guest user. Disabling that will force the client to pass the credentials.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Cant locate SQL Server Express from client pc

Hi,

I have a 5 user network running SBS 2000.

I have installed SQL Server Express on one of the client machines (not the SBS Server) I can connect locally without problem. However i cant connect from the other client machines.

I have enabled TCP/IP, Remote Connections Etc

I am attempting to test the connection using an .udl file. The server name is found but i still cant connect.

Any help would be apreciated.

Hi,

the error message would be helpful for us.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi

I am using the following information on the Data Link Properties Dialog:

Provider: Microsoft OLE DB Provider for SQL Server
Server Name: DIMENSION1100\SQLEXPRESS

Use Windows NT Integrated security

At "Select the database on the server" combo i recieve the following error:

[DBNETLIB] [ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Loging Failed Catalog information can not be found

Thanks

|||

Hi,

I have now managed to connect to SQLServer Express from the remote machine, but the only databases available are:

Master, msdb and tempdb.

Any ideas?

Thanks

|||SQL Server 2005 introduced the feature that only objects where you have permissions on are reflected in the Information_Schemas and in the other interfaces. So, I guess the user you are connecting to the database isn′t priviledged to access the databases.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi,

Thanks for the quick reply. I have started to look at permissions but there's alot to take in, where do i begin? Is there an easy way to allow 100% access then lock down at a later date? (Just to test connectivity)

Thanks for your help

|||Grant the database role dbo to the user.

But keep in mind to change the role after testing (!) :-)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Where is this done from?

Also are there any instruction available that outline security for sql express running in Windows Authentication mode?

Thanks again for all your help.

|||

Hi,

"Played around" < with 'user mapping' via ssms and gained access from remote pc's.

Thanks.