Instances Of SQL Server Have Disappeared

Jan 13, 2005

Hi,





We had 5 instances of SQL Server running on one of our machines and everything looked to be working fine. Today I installed another instance for a new application and once done and rebooted the new instance didn't show in the SQL Server Enterprise Manager. At this point we decided to uninstall it. After that 4 of the existing instances have diapered as well even though they are running and responding requests from their respective applications.





I did some googling and all I could see is something related to a command called nscontrol but I couldn’t find any nscontrol executable on that machine.





Does anyone have any idea what this problem could be?





Thanks

View 5 Replies


ADVERTISEMENT

SQL Server Counters Disappeared

Nov 10, 2005

On Tuesday the SQL Server Counters showed up in Performance Monitor. Yesterday they were gone. Is there any way they could have disappeared other than someone explicitly deleted them? How would I go about restoring them? Obviously, I'm concerned.

Thanks for the help.

View 4 Replies View Related

Generating User Instances In Sql Server Is Disabled. Use Sp_configure User Instances Enabled To Generate User Instances.

Sep 28, 2007

 When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances." I am currently using SQL server 2005 Express. What do I need to do, to create an SQL database? Thanks in advance. 

View 4 Replies View Related

Named Instances And Default Instances Of SQL Server 2000

Jul 18, 2001

I had a server with SQL Server 7.0
I installed a named instance of SQL Server 2000 and then i passed all my DB
of the 7.0 instance to the 2000 instance.
Then i removed the 7.0 instance, that was the default instance.
So at the moment there is only the 2000 version, but it isn't the default
instance
Can the 2000 instance become the default instance? (So that clients can
connect to it simply through computer name, and not creating an alias)

thanks

Fede

View 1 Replies View Related

Job History Disappeared

Dec 17, 2007

Today when I tried to troubleshoot a failed job, I found out that the job history is disappreared. Some jobs' history still exist. Does anybody have idea what happened? How can I fix it?

Thanks a lot.

View 4 Replies View Related

SQLServer Dll's Disappeared

Feb 19, 2007

When I removed/re-installed SQLServer 2005 (Express) all of my dll's related to SQL Server disappeared from C:ProgramFilesMicrosoft SQLServer90SDKAssemblies:  .ConnectionInfo, .Smo,.SMOEnum,.SQLEnum,.WmiEnum that I know of - maybe more. 

How can I re-install these?  Are they in the SQL kit, VB, SDK ???

Any help would be appreciated. 

 

 

 

 

View 3 Replies View Related

Guest Id In Tempdb Disappeared.

Feb 28, 2001

Hi All,
I encountered a bizzard situation. The guest id in tempdb disappeared after I rebooted (shutdown and startup) my server. That caused errors in application whenever a stored proc needs to create a temporary table.
Has anyone seen this happened before? Any idea on why or how it happened?
Thanks in advance.

View 1 Replies View Related

Stored Proc Disappeared

Mar 20, 2002

I have a stored procedure that for some reason disappeared on me. When I do “select * from the sysobjects”, it’s there. When I look at it from the EM, it’s not there. I refreshed everything a lot of times. Here is the data I get from the sysobjects:

myproc90587511U 141610615041224002002-01-26 15:41:13.44702240U 18302002-01-26 15:41:13.447000005200

Any help would be greatly appreciated.

View 3 Replies View Related

Permissions Set To Roles Disappeared

Sep 13, 2007

We setup a number of roles with access rights to tables in the DB. This week for some unknown reason, rights on these roles disappeared.
We had to run a restore to reset the roles in the database. After the restore, we could not reproduce the problem.
Are there scenarios to avoid that would cause rights to drop from roles and users? (These rights were gone not just hidden)


Tim.

View 7 Replies View Related

The Body Of The Report Disappeared

Feb 6, 2008


Hello,
I was modifying some standard reports of one planning program, by downloading .rdl file from report server and creating a new report project. I have done so many times.
Last weak in one of those new reports only header of the report was seen in the report server as I thought I had made some kind of mistake tried to look for it, and after some time the problem fixed itself and I blamed everything on one mixed up connection between the tables in the report, because after removing it the problem fixed itself, but now I think that was just a coincidence.
This weak after working fine for about a weak, 6 reports appeared as only headers and footers, they worked fine yesterday and no changes were made to the reports, but in the morning only the header is seen.
The reports that are affected are the 4 new ones, and 2 original ones, they are all dealing with the same date just different grouping and sorting.
Does anyone know how to fix this problem?

Darius

View 1 Replies View Related

Nt Groups Disappeared In Security Manager

Jun 13, 2000

hi,
i have starange problem here.
i have total 10 nt groups mapped to security manager.
today when i opened security manager it is saying no groups
in the security manager,security manager is blank.
i am using mixed security mode.
pls give me any ideas..
it is very ugent pls..
Thank u very much

--Kavira

View 3 Replies View Related

Data Disappeared (Users Missing)

Sep 3, 2006

hello,
am not sure if this is the right forum to post this.

We have a couple of sites running MS SQL, however we have never had issues with data corruption.

I was working with a certain site and then noticed that all users in the users table were missing except one.

Secondly, the users table had all permissions revoked.

how did this happen and whats the best way to go about restoring it.

Ehi

View 5 Replies View Related

System Databases Folders Disappeared From SSMS 9.0

Jun 14, 2007

Suddently System Databases Folder is not showing on Studio 9.0 for all the SQL servers instance. Do you know why ? Is there any option other than De-attach them?

View 4 Replies View Related

SQL Server Instances

Mar 5, 2007

Hi Dears, How can i detect the Local SQL Server instance (server name, uid, pwd) installed in a standalone systemusing C# 2.0?I used the fucntions available in odbc32.dll, but it only returns the result while the systemis connected in network.can any one resolve this....?thanks in advance...yenkay  

View 5 Replies View Related

Sql Server Instances

Jul 30, 2001

with sql server 2000, it is possible to have multiple instances on one server. Now I want to make the second server a subscriber for specific tables before there are some tests/major changes. Has anyone experience with this on the same server. Note : sql server subscriptions between different servers in sql server 7 is not the issue.

View 1 Replies View Related

Instances Of SQL Server

Sep 20, 2001

I created a named instance of SQL Server 2000 on my notebook. I inadvertantly set the trusted SQL connection to Windows Authentication. This is creating a problem with COM because of username and password. I want to reset it to use SQL Server authentication but I can't find where to do it. Can I do this or do I have to delete this instance and create a new one.

View 1 Replies View Related

Instances On SERVER

Jun 4, 2008

Hi Gurus,

What process i should folloew to ctrae instance on server.



Thanks,
ServerTeam

View 1 Replies View Related

SQl Server And Instances

Mar 25, 2008

Can someone explain what "named instances" means with regard to SQL?

Is this one Physical Server With multiple installs of SQL SERVER and / or databases ?

We have a list at my small comapy with "raw sql 2000 database instances". Can someone help out, I'm getting conflicting info!

Thanks,

Scott M

View 2 Replies View Related

SQL Server Instances

Aug 8, 2005

Dear SQL Guru,I just found out this morning that my SQL Server box had been added 1more instance. Below is the example:PPAPP0075FINANCE (Old instance)PPAPP0075ACCOUNTING (Old instance)PPAPP0075Accounting (new instance)This is a case sensitive MS Sql server (third party vendor App). TheACCOUNTING instance is the one we have been using for our currentapplications. I found out the new one(Accounting) when I scan thenetwork by using OSQL -L utility. However, when NT engineers tried toverify the physical files location ofAccounting, and it did not exist. When I tried to register it and itdoes not appear from Enterprise Manager.Please keep in mind NT Engineers have been monkey around on this serverquite a lot in last a few weeks, especially modifying Registry keys.My question is, where did PPAPP0075Acounting come from? We never evertried to install any more instance on this server.Please help,Thanks,Silaphet,

View 1 Replies View Related

SQL SERVER Instances

Jan 17, 2006

Hi all,

I already have a copy of SQL SERVER 2000 installed on my current local machine.
How is it possible that I create another second instance for example TEST/silkkeng in SQL Server Enterprise Manager? OR SQL query ?
Is it possible ? Or the only solution is ReInstall SQL to create another instances?

View 1 Replies View Related

SQL Server XE Instances In .Net

Jul 10, 2006

Hi, I've got an application which uses the DBFactory Provider to enumerate a list of available SQL instances on the local network.

I've just reformatted though and put everything back on, and my application will now see the sql server instances on the network, but not the instances on the local computer (only the server name), eg, it will see "BENSQLEXPRESS" on a computer (BEN) on the local network, and give the version info, etc, but it only sees "DAN" instead of "DANPCP" and "DANSQLEXPRESS" on the local computer (DAN).

Regards,

Ben

View 5 Replies View Related

SQL Server Instances

Dec 29, 2007



Hai,
One more question with related to SQL Server, I was using SQL Server 2005(Express Edition).

I was using SQL Server Instances as

.SQLExpress

Suppose if i install the Enterprise Edition , what is the default instances and other build-in instances:

Thanks.

Regards
Kashif Chotu

View 1 Replies View Related

Different Instances Of SQL Server

Jul 31, 2007

Hi there,
I was wondering if it's possible to create a new instance in the SQL Server something like this:

(Local)\MSSMLBIZ

(Local)\BUSINESS

Thank you

View 5 Replies View Related

SQL Server 2000 + 2005 Working On Same Windows 2003 Server As Seperate Instances

Nov 20, 2006

Hi all,I just asked some people to help me out and phone microsoft with thefollowing information, kindly they refused unless we setup a supportcontract with them first, for pre-sales information. (That really doesnot sound like good business sense to me - anyway here is our problem,if anyone could help thanks)."To tell and ask microsoft:We will be setting up a microsoft sql server 2000 instance running on awindows 2003 server.1) We need to check this can run alongside a microsoft 2003 sql server(either workgroup or standard edition), on the same machine. Are thereany .dll clashes if we do this? If there are can we run SQL Server2000, in a virtual machine running windows 2000 professional. (I have alicenced copy we can use for this).2) If we run one instance of 2000, and one of 2003 of the sql servers,can one use the processor licence model, and one use the CAL licencemodel."Thanks for any help, and any idea why they actually force you to usenews groups for pre-sales information?David

View 4 Replies View Related

SQL Server Admin 2014 :: Multiple SSRS Instances On Same Server

Jun 23, 2015

I am playing around in a test environment with SQL Server 2014. I have a question about the default location of the report server databases when you have multiple report server instances installed on one server.

I did a very simple install of SQL Server 2014 with the database and Reporting Services in Native Mode (install only) features selected. Accepting the default locations, I ended up with the following locations as you would expect:

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVER
C:Program FilesMicrosoft SQL ServerMSRS12.MSSQLSERVER

Running the Reporting Services Configuration Manager, I created the Report Server database. After creating the Report Server database, the related files will be located below in the SQL folder as I would expect.

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATA

Next I installed another instance, which I called Test, of SQL Server 2014 like I did above. I now have the following folder structure the Test instance as I expect.

C:Program FilesMicrosoft SQL ServerMSSQL12.TEST
C:Program FilesMicrosoft SQL ServerMSRS12.TEST

Running the Reporting Services Configuration Manager, I select the Test instance and create the Report Server Test instance database.

My first thought would be that the Test instance Report Server database would be in the following location:

C:Program FilesMicrosoft SQL ServerMSSQL12.TESTMSSQLDATA

Instead this database is located with the default instance Report Server database:

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATA

View 2 Replies View Related

SQL Server Instances And Its Database

Apr 3, 2007

Hi,
       I want to list the instances SQL server in the network and their corresponding database. I found an API which list the server names in the network, but only for the main SQL server it is connecting and listing the database. For others it times out and gives run time error [DBNETLIB] Connection Open () SQL server doesn¡¯t exist or access denied
could anyone help on this

View 1 Replies View Related

Multiple Instances Of SQL Server 7 & 2K

May 22, 2001

I am running SQL 7.0 as the default instance and SQL 2K as a named instance. Each is using a different port....7.0 is using port 1433 and 2K is using 1024. Everything appears to be up and running fine on the server. However, I am not able to access the 2K instance from a client. I have tried to use both TCP IP and named pipes setting them up using the server network utility and the client network utility. No luck anywhere. I continue to get connection errors...check network documentation...

ANY IDEAS??????

View 3 Replies View Related

SQL Server Instances In A Cluster

Feb 25, 2003

I an involved in a project that will have five sql server instances on an NT cluster.
I cannot find anywhere on Technet info on what happens when a single instance fails. Do they all have to fail over or just the failed instance. This is important so that we get the disk layout correct.

Can anybody help ? or point me to any docs on this.

View 1 Replies View Related

SQL Server Named Instances

Apr 11, 2006

Informatica jobs were erroring out with a sql server driver error
while connecting to a named instance in SQL Server.
The issue was because in sql server named instance, the port was allocated dynamically and Informatica 7.1.4 (provides 4.21 version of Datadirect odbc drivers for SQL server) which dont have support for named instances with dynamic port allocation. This feature is only present from version 5 of the Datadirect odbc drivers for SQL server
To fix this issue, I need to allocate the port for the named instance instead of getting it dynamically.
My questions
1) Whats the impact of doing a port allocation for the named instance on the existing environment.
2) Is there any issues which we can foresee in the applications
3) Things which i need to be aware of
Thanks in advance
sreenath

View 3 Replies View Related

More Than 16 Instances Of SQL Server 2000

Sep 12, 2006

I need any information on whether its possible to create more than 16 instances of SQL Server 2000. I know Microsoft says they don't support over 16 but what are the downfalls of doing this? How many could possibly be put on one server?

View 1 Replies View Related

Hoe To Connect Two Different Instances Of SQL SERVER

Apr 29, 2004

How to connect two differect instances of SQL SERVER on LEN or WAN for Data Migration.

View 1 Replies View Related

SQL Server Multiple Instances

May 8, 2008

Is there any limit on SQL server Multiple Instances? if we require to run 60+ Instances on single machine what will be the minimum hardware requirements.

View 3 Replies View Related

Could Not Get SQL Server Instances Names

Jun 10, 2008

Hello,

Here is my setup:

2 node active/passive Microsoft cluster running SQL 2005 Enterprise Ed w/ SP2. The SQL setup is configured as a named instance, servernameinstancename. When I tried to install SCOM 2007, I'm getting this error, "Could not get SQL server instances names."
What could be the cause of this error? Any help would be appreciated!!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved