I don't see my databases. How to recover from this

Hi,
I have a lot of databases in my server, but the point
here is that I cannot see none. When Enterprise Manager
starts there's an error appearing:
snap-in failed to initialize
Name: Microsoft SQL Enterprise Manager
CLSID: 00100100-1816-11D0-8EF5-00AA0062C58F
After this error, in the Enterprise Manager my databases
have disappeared.
Is there a way to recover from this? I really need
somebody's help, please.
Thanks in advance.
Renato VizuetTry to re-register the server.
>--Original Message--
>Hi,
>I have a lot of databases in my server, but the point
>here is that I cannot see none. When Enterprise Manager
>starts there's an error appearing:
> snap-in failed to initialize
> Name: Microsoft SQL Enterprise Manager
> CLSID: 00100100-1816-11D0-8EF5-00AA0062C58F
>After this error, in the Enterprise Manager my databases
>have disappeared.
>Is there a way to recover from this? I really need
>somebody's help, please.
>Thanks in advance.
>
>Renato Vizuet
>.
>

I don't see Database Maintenance Planner in my SQL Server Enterorise Manager

Strange..... Anyways, is it possible to add the tool for Database Maintenance Planner to the existing DB installation?

If so, how do I do that? Would someone please help me on this?

Thanks a lot in advance.

Chris.

Hi Chris. If you don't see it, that could mean you aren't logged in as a sysadmin, they are the only logins that are allowed to view/modify maintanence plans.

It should be visible under the Management node in Enterprise manager, then a node called 'Database Maintanence Plans'. You should never see it under a specific database if that's where you are looking, not sure from your post if that may be where you were headed...

As for adding it to an existing installation, that's not really something that ever would need to be done...it's part of all installations, so it should already exist if the installation was successfull to any degree.

HTH,

|||

Having read your kind explanation above, it really make sense!

With confidence backed by your explanation, I will look into the SQL installation (which I did not install myself) and login users on Monday.

Once again, thank you so so so much, Chad. I wish I could buy you a drink!

Chris,

|||No problem Chris, glad to help. Repost if you still continue to have issues finding it...I'd take that drink if I could too!sql

I changed a report name, and get error "Execution 'fralkj45eeyh0te5opip4455' cannot be fo

hi

What I did is in VS2005, right click the report name, change it and then rebuilt it, deploy it. And then go to Report Manager, I can see the new one, but when i run it, it shows this error:

Execution 'fralkj45eeyh0te5opip4455' cannot be found

what does this mean, does anybody know how to fix it?
thanks.

It should be fine after changing the name.
I delete it from report manager, and re-build, delopy to the report server, then it works fine.

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
Pippo
Hi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
PippoFrom what you have said you do not have access rights to
start it.
Can you give me some more details on your set up i.e.
client server, stand alone ect ?
>--Original Message--
>Hi,
>In SQL Server Service Manager, when i start the Sql
>Server Service, the service don't start. There is a An
>error 5 (Access Denied).
>How can resolve it?
>Thank for all
>Pippo
>.
>|||Hi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo|||This service started, and now don't start,
if I start the service from prompt i have I more
descriptions from the errors'
How i can start the service from prompt?
Thank for All
Pippo
>--Original Message--
>From what you have said you do not have access rights to
>start it.
>Can you give me some more details on your set up i.e.
>client server, stand alone ect ?
>
>>--Original Message--
>>Hi,
>>In SQL Server Service Manager, when i start the Sql
>>Server Service, the service don't start. There is a An
>>error 5 (Access Denied).
>>How can resolve it?
>>Thank for all
>>Pippo
>>.
>.
>|||Hi,
To start the default instance of SQL Server from a command prompt
sqlservr.exe -c
To start a named instance of SQL Server
sqlservr.exe -c -s {instancename}
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:19e9b01c41d4d$329947d0$a301280a@.phx.gbl...
> This service started, and now don't start,
> if I start the service from prompt i have I more
> descriptions from the errors'
> How i can start the service from prompt?
> Thank for All
> Pippo
>
> >--Original Message--
> >From what you have said you do not have access rights to
> >start it.
> >
> >Can you give me some more details on your set up i.e.
> >client server, stand alone ect ?
> >
> >
> >>--Original Message--
> >>Hi,
> >>In SQL Server Service Manager, when i start the Sql
> >>Server Service, the service don't start. There is a An
> >>error 5 (Access Denied).
> >>How can resolve it?
> >>
> >>Thank for all
> >>
> >>Pippo
> >>.
> >>
> >.
> >

I can't start SQL Service

Hi,
In SQL Server Service Manager, when i start the Sql
Server Service, the service don't start. There is a An
error 5 (Access Denied).
How can resolve it?
Thank for all
PippoHi,
Did you changed the service startup account or revoked from previleges.
As a solution, Try to start the SQL server with one of the below users and
try, this problm normally comes if the service start up user do not
have permission to access the SQL server registry or some folders.
Domain user who is in Admin group of SQL server machine
or
Change the startup account to Localsystem account
Thanks
Hari
MCDBA
"Pippo" <anonymous@.discussions.microsoft.com> wrote in message
news:170d301c41d3e$b6d29b50$a601280a@.phx
.gbl...
> Hi,
> In SQL Server Service Manager, when i start the Sql
> Server Service, the service don't start. There is a An
> error 5 (Access Denied).
> How can resolve it?
> Thank for all
> Pippo

i can't save my DTS

here's my problem :
i've created a DTS with enterprise manager directly on the server, and
everything was ok for some days.
But i've modified this DTS on a distant computer and since i've done it,
i've an access denied message when i try to save or execute any dts on the
server. I've acces to everyting else on the entreprise manager (i'm using
a system administrators account) but the only thing i can do with the DTS
is deleting.
On the other side, i can do everything on the DTS on the distant computer.
pleaaaaaaaaaaase...help meeee !!!See if you can run the same commands that the DTS package is executing from
OSQL or ISQL.
Access Denied maybe permissions with the filesystem rather than DTS or SQL.
You can run FileMon.exe from www.sysinternals.com to see where the
permission problem is.
Hope this helps.
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||What was the error message when saving the DTS package?
--
--
Satya SKJ
"jc@.leman-industrie.fr" wrote:

> here's my problem :
> i've created a DTS with enterprise manager directly on the server, and
> everything was ok for some days.
> But i've modified this DTS on a distant computer and since i've done it,
> i've an access denied message when i try to save or execute any dts on the
> server. I've acces to everyting else on the entreprise manager (i'm using
> a system administrators account) but the only thing i can do with the DTS
> is deleting.
> On the other side, i can do everything on the DTS on the distant computer.
> pleaaaaaaaaaaase...help meeee !!!
>

I can't disable publications

Enterprise Manager hangs every time I try to disable publications. I
tried stopping, then deleting individual subscriptions before trying to
delete the publication, but EM would hang after each one. I gave it 30
minutes to complete, but it never came back. Now I have phantom
subscriptions on the remote machines, even though the distributor shows
none.
I've always been able to follow the above steps before. I don't know
why it suddenly went bonkers.
I've tried rebooting the server (this is a production system, so I'm
hesitant to do that again), and that had no effect. I don't have
physical access to the machine.
Is there a manual way to safely disable publishing and then use the
wizard (or manually) to enable it again?
BTW, this is merge replication.
try running sp_droppublication manually from QA.
Either that or run sp_who2 to figure out which process is blocking.
Sometimes you get better results if you issue a master.dbo.xp_cmdshell 'net
stop SQLServerAgent' before attempting the drop.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"vibrantice@.hotmail.com" <rob.bartlett@.gmail.com> wrote in message
news:1128814964.404168.281580@.g47g2000cwa.googlegr oups.com...
> Enterprise Manager hangs every time I try to disable publications. I
> tried stopping, then deleting individual subscriptions before trying to
> delete the publication, but EM would hang after each one. I gave it 30
> minutes to complete, but it never came back. Now I have phantom
> subscriptions on the remote machines, even though the distributor shows
> none.
> I've always been able to follow the above steps before. I don't know
> why it suddenly went bonkers.
> I've tried rebooting the server (this is a production system, so I'm
> hesitant to do that again), and that had no effect. I don't have
> physical access to the machine.
> Is there a manual way to safely disable publishing and then use the
> wizard (or manually) to enable it again?
> BTW, this is merge replication.
>
sql

I cant connect to my SQL database using Enterprise Manager :(

Hello,

I am trying to solve this problem for the past 1.5 weeks and it is driving me crazy :(

I can't connect to my SQL database using Enterprise Manager, Query Analyzer, Visual Studio 2003 .NET or a .aspx that I created for testing.. it runs perfectly on my domain but it doesnt work on my computer, on the browser I get this message: SQL Server unavailable or access denied. It is the same message I get when I try connecting to my db using EM, QA, VS.NET etc :(

I can ping my sql domain, so I know I have access to it and it is working.. I can successfully connect to my personal SQL server running on my machine. (SQL Server Personal Edition running on Windows XP )

I tried doing everything I could,

I already selected TCP/IP as my client only protocol;
I tried installing the lastest MDAC (v 2.8);
I tried every other port on my TCP/IP client setup like 14333 or 11433 or 11143 etc;
I tried every other port on the alias I set for my sql address;
I tried downloading the evaluation version of MS SQL2000 and updating it to SP3;
I tried reinstalling several times my MS SQL2000 (I use the personal edition on my windows XP) and updating it to SP3;
I tried connecting to my sql address domain and directly to its IP;
And I tried a lot more resolutions that I can't remember right now, but it didn't work :(

I've been searching all forums/google etc looking for someone with my problem but I still didnt, everyone who had a problem connecting to their DB using EM or QA resolved it by doing "this or that", I did exactly the same "this or that" on my computer/config and it didn't resolve my problem. :(

What am I doing wrong? I can't connect to my database from my personal computer :(

I have never used enterprise manager before, so I don't know if it is a problem on my personal computer or on my sql server address on internet.. Is there anyway to find a free test ms sql database with like 1mb just to try and find out if I can connect to a sql database at all using EM or if the problem is here on my computer?

Thanks in advance for any help,
XandeHI ,

I had similar problems , are you going through a firewall? also did you try typing in the ip addy instead of the server name?

Burner|||Hello,

Yes, I tried typing the IP and I already opened the port 1433 on my router DSL.. :(

Thanks|||HI ,

do you guys use port 1433, try port 2433.Do you guys connect through a firewall if yes type in the server on which the firewall resides IP...and port 2433 and see ...

I cant add a odbc

Hi, how the subject say. I have problems for register
databases server or odbc. When i try to do it, the
enterprise manager send the next message:
A connection could not be established to "SERVER"
Reason: Specified driver could not be loaded due to
system error 126 (SQL Server)
In the otherwise the odbc send the next error:
The setup routines fot the SQL Server ODBC driver
could not be loaded due to system error 126
Please, help me.
Thanks !!!
I suggest installing the latest MDAC 2.8 version that you can download from
www.microsoft.com/data.
Michael Otey
<anonymous@.discussions.microsoft.com> wrote in message
news:2be5301c468fe$5ff8a890$a501280a@.phx.gbl...
> Hi, how the subject say. I have problems for register
> databases server or odbc. When i try to do it, the
> enterprise manager send the next message:
> A connection could not be established to "SERVER"
> Reason: Specified driver could not be loaded due to
> system error 126 (SQL Server)
> In the otherwise the odbc send the next error:
> The setup routines fot the SQL Server ODBC driver
> could not be loaded due to system error 126
> Please, help me.
> Thanks !!!
>
|||Thanks, it was the problem...

>--Original Message--
>I suggest installing the latest MDAC 2.8 version that you
can download from
>www.microsoft.com/data.
>Michael Otey
><anonymous@.discussions.microsoft.com> wrote in message
>news:2be5301c468fe$5ff8a890$a501280a@.phx.gbl...
>
>.
>

I cant add a odbc

Hi, how the subject say. I have problems for register
databases server or odbc. When i try to do it, the
enterprise manager send the next message:
A connection could not be established to "SERVER"
Reason: Specified driver could not be loaded due to
system error 126 (SQL Server)
In the otherwise the odbc send the next error:
The setup routines fot the SQL Server ODBC driver
could not be loaded due to system error 126
Please, help me.
Thanks !!!I suggest installing the latest MDAC 2.8 version that you can download from
www.microsoft.com/data.
Michael Otey
<anonymous@.discussions.microsoft.com> wrote in message
news:2be5301c468fe$5ff8a890$a501280a@.phx
.gbl...
> Hi, how the subject say. I have problems for register
> databases server or odbc. When i try to do it, the
> enterprise manager send the next message:
> A connection could not be established to "SERVER"
> Reason: Specified driver could not be loaded due to
> system error 126 (SQL Server)
> In the otherwise the odbc send the next error:
> The setup routines fot the SQL Server ODBC driver
> could not be loaded due to system error 126
> Please, help me.
> Thanks !!!
>|||Thanks, it was the problem...

>--Original Message--
>I suggest installing the latest MDAC 2.8 version that you
can download from
>www.microsoft.com/data.
>Michael Otey
><anonymous@.discussions.microsoft.com> wrote in message
> news:2be5301c468fe$5ff8a890$a501280a@.phx
.gbl...
>
>.
>

I cannot get Enterprise Manager to remotely connect!

I have an ASP page that is pulling data from an SQL server 2000 database. The code connects just fine using the specified Username and Password which was set up by the admin.

However, using that same username and password, I cannot get connected using Enterprise Manager SQL registration method so I can change database settings.

The error message I get says: SQL server does not exist or access denied (Conection Open(connect)).

The SQL server does exist (because it finds it in the server list). For some reason I am getting access denied. The server is running a mixed authentication mode.if sql2000 is running on win2003,it must be fix by sql service pack .
then you can settle the problem.|||I am trying to connec to a machine running win2000.|||Are you registering by machine name or ip address ? Can you ping the server ? When you say remotely - please provide more details on this ?|||Remotely means outside the firewall. I have also tried to connect inside the firewall. Inside the firewall, the server is listed by name in the available servers list when registering a new server. It just won't connect. Outside the firewall I am typing the IP in and nothing. SQL server is running on the webserver I am working off of.|||Can you ping the sql server (from inside or outside) ? Did you try using the ip address when registering from inside/outside ? What does your client network utility show as far as enabled protocols ? What are the errors you receive inside/outside ? Are you using the same machine to connect in both example (inside/outside) ?|||Also, since a firewall is involved - validate that the sql port is open. The default/normal port is 1433, but might have been changed by the sa/dba for security.

i can use SQL2005 Client Tools with SQL2000?

hi
i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and run
SQL Statement?
--
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================Absolutely have been for 18 months now
--
Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:utkx4v%23YGHA.4620@.TK2MSFTNGP04.phx.gbl...
> hi
> i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and
> run SQL Statement?
> --
> Best Regards
> Tark M. Siala
> Development Manager
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================>|||Definitely use Management Studio for all your databases, both SQL2005 and
SQL2000.
The only thing I think is a pain with it would be that when you generate the
script for an object, the drop statement isn't there. But it's not a
show-stopper, and you'll find that many of the features really help.
"Simon Sabin" wrote:
> Absolutely have been for 18 months now
> --
> Simon Sabin
> SQL Server MVP
> http://sqljunkies.com/weblog/simons
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:utkx4v%23YGHA.4620@.TK2MSFTNGP04.phx.gbl...
> > hi
> > i can use SQL2005 Client Tools (lik vs2005) with SQL2000, to control and
> > run SQL Statement?
> > --
> > Best Regards
> >
> > Tark M. Siala
> > Development Manager
> > INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> > Mobile: +218-91-3125900
> > E-Mail: tarksiala@.icc-libya.com
> > Messenger: tarksiala@.hotmail.com
> > Web Page: http://www.icc-libya.com
> > Blog: http://spaces.msn.com/tarksiala
> > ======================================> >
>
>|||Is there an automatic completion feature ?|||SoftLion wrote:
> Is there an automatic completion feature ?
>
Do you mean Intellisense? Not built-in, but SQL Prompt (free download)
will give you that capability. Works with the 2000 client tools as well.
http://www.red-gate.com/

I can no longer connect to my SQL Server Express 2005 from Manager Studio Express

Everything was working fine. I have been able to connect using windows authentication. Then, I went into the ODBC manager to add a data source and it failed to connect so I went back into the Server management studio to modify users. After doing this I now get an error when I try to conenct the management studio to the SQL server.

I wasn't modifying the login for my windows account that I normally use, I was modifying a different one, however I now get the message "An error has occured while establishing a connection to the SQL server. This kind of problem can ocure because the default behavior of the server does not support all connection methods" blah blah.

Does anyone know how I can attach to the server? Or, do I need to somehow remove the server and create a new one? How would I do that?

Thanks in advance for any input.

Hi,

did you disable remote connections by accident ? If so, see if this feature is enabled under the Serface Configuration. See more detaisl on the screencast on my site.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de