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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Jun 4, 2008
Hi Gurus,
What process i should folloew to ctrae instance on server.
Thanks,
ServerTeam
View 1 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
Apr 29, 2004
How to connect two differect instances of SQL SERVER on LEN or WAN for Data Migration.
View 1 Replies
View Related
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
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