Default Instance On Virtual SQl Server
Mar 12, 2008
Hi,
Can I Install a default instance on Virtual SQL Server on a 2 node Cluster. If I already have a default instance on a different Virtual SQL Server on the same clustered Server.
What i am trying to do..
if i create 2 virtual sql Server (say sqlVi1 and sqlVi2)..
i want o connect using sqlVi1 and sqlVi2..not Sqlvi1 and SQlvi2Namedinstance.
If yes..How can I do it?
Thanks in advance
I Hope someone from Microsoft or MVPs will help me.
if this is not the corrcet forum...please point me the correct one
View 3 Replies
ADVERTISEMENT
Nov 15, 2007
The box I am trying to connect to is running two instances of SQL Server.
There is a SQL Server 2005 instance which is the default. There is a SQL Server 2000 instance which is named 'SQLSERVER'.
I can connect to the SQL Server 2000 instance no problem:<add key="ConnectionString" value="server=MYPCSQLSERVER;database=mydatabase;user id=****;password=****" />
However, I am having trouble connecting to the Default SQL Server 2005 instance. I have tried:
<add key="ConnectionString" value="server=MYPC;database=mydatabase;user id=****;password=****" />
but it doesn't work. I have tried explicitly setting SQL Server 2005 to use port 1434 (as SQL Server 2000 is running on port 1433), and then used:
<add key="ConnectionString" value="server=MYPC,1434;database=mydatabase;user id=****;password=****" />
but this doesn't work either.
Am I mssing something here? Any help much appreciated
Thanks...
View 2 Replies
View Related
Apr 10, 2007
Hi,
I have RS 2000 running on windows 2003 server. I want user to subscribe to reports and receive reports via email. Initially SMTP was not installed for IIS 6.0, so I installed it and the right way (I had done it on different machine before and was succefull in that) but on this particular machines ...I don't see "Default SMTP Virtual Server" node when I open IIS manager.
This is the third day I am working on this issue ..please help me out guys,
prashant
View 1 Replies
View Related
Feb 19, 2007
Hi, I have a task in hand to migrate (upgrade) from SQL2K named instance to SQL2K5 default instance. There are many intranet applications touching current SQL2K. I would like to perform this upgrade such that I don't have to touch any application code - meaning I don't have to change the connectionstring to point to new Default instance. How can I achieve this?
So, in otherwords, here is what I want to achieve:
Current Server: SQL2K: SERVER_AINSTANCE_A (named instance)
Upgraded Server: SQL2K5: SERVERB (default instance)
If I have both default, I could achive this by setting up DNS alias after migration done so that any call for SERVER_A would point to SERVER_B. But in my case, I don't have SERVER_A, I have named instance. Is there any solution?
Regards,
Vipul
View 1 Replies
View Related
Jun 8, 2007
We regularly deploy our product to client's sites and install a named instance of SQL Server 2005 and Reporting Services on their Windows Server. We use the instance name "lgs" during SQL setup and it automatically ensures we have a http://server/Reports$lgs and http://server/ReportServer$lgs to work with.
A recent deployment had some trouble with their OS and we have needed to reinstall the Reporting Services component of SQL. After reinstalling, the virtual directories for Reports$lgs and ReportServer$lgs are gone. I have used the Reporting Services Configuration tool to create new virtual directories but when I enter Reports$lgs or ReportServer$lgs as the names I get an error. The error says that the virtual directories cannot
be created due to illegal characters in the names.
How can I create the same virtual dirs that would have normally been created during initial installation?
Thanks,
- Jason
View 1 Replies
View Related
Jul 23, 2005
Currently I have a server that has two instances of SQL Server that areboth heavily used. We are moving the databases that are on the defaultinstance of this server to a new server. Since the old server willonly need one instance (the current named instance) of SQL Server isthere a good way to remove the default instance and make the namedinstance the default? If this change is possible will the name of thecurrent named instance need to be changed? Will all of the programscurrently accessing the named instance need to change their connectionstring?
View 2 Replies
View Related
Oct 10, 2001
I am trying to set up a Named Instance of SQL 2000 on the same machine that has a default instance of SQL 7.0. The setup always completes and I am able to register the Named Instance of the SQL Server with which it was installed on. However, when I try to connect the users to the database, with both windows and SQL authentication, I receive a SQL server not found error. I have tried an alias setup as well as physically specifying the port number in settup up an ODBC connection.
Has anyone ran into similar problems?
Also, has anyone been able to successfully complete the process as mentioned above?
View 1 Replies
View Related
Mar 2, 2007
I have a server with sql server 2005 installed as the default instance -- I have a piece of software that needs SQL2000 to be the default instance. Is there a way other than install new sql2005 named instance and move databases to rename my SQL2005 instance from <machinename> to <machinename>sql05 for example?
Bryan
View 2 Replies
View Related
Nov 7, 2007
I have question about install both default instance and name instance on to one server. Do I need follow a specific order such as default instance first then name instance?
If my server already has two or more name instances, can I install one more default instance?
Thanks
View 1 Replies
View Related
Feb 27, 2007
Hi, I hope someone can help me! I changed the TCP port that the default instance of SQL 2005 x64 SP1 is listening on and now SQL server won't start as the port is being used - no problem I say to myself, I'll just change it again, however I can't!
My problem is that I can not change the TCP Port back again using Configuration Manager - no matter what values I put in, after a restart of the instance it comes up with this in the IP Addresses tab for TCP/IP Properties and SQL Server won't start:
IP1
Active Yes
Enabled No
IP Address aaa.bbb.ccc.111
TCP Dynamic Ports
TCP Port 0
IP2
Active Yes
Enabled No
IP Address aaa.bbb.ccc.222
TCP Dynamic Ports
TCP Port 0
IP3
Active Yes
Enabled No
IP Address aaa.bbb.ccc.333
TCP Dynamic Ports
TCP Port 0
IP4
Active Yes
Enabled No
IP Address 10.1.1.1
TCP Dynamic Ports
TCP Port 0
IP5
Active Yes
Enabled No
IP Address 127.0.0.1
TCP Dynamic Ports
TCP Port 0
IPALL
TCP Dynamic Ports 2020
TCP Port 2020
Interestingly, the ip address that the server is listening on aaa.bbb.ccc.444 is not reported in the list of IP addresses in the configuration manager for this instance, yet it is when I view the available IP addresses for the other two instances - is this significant?
I have tried failing to the other node, changing it there, changing it at the console and also while logged onto the the virtual machine remote desktop, rebooting both nodes, etc, etc. There are two other instances on this cluster that are still working fine but I hvae not attempted to change the TCP ports they listen on.
I used the same method to change this default instance as I did for a named instance on a similarly configured cluster and it worked fine. How to fix this?
Regards, Mike
2007-02-27 12:03:17.69 Server Server is listening on [ aaa.bbb.ccc.444<ipv4> 2020].
2007-02-27 12:03:17.71 spid9s Starting up database 'tempdb'.
2007-02-27 12:03:17.72 Server Error: 26023, Severity: 16, State: 1.
2007-02-27 12:03:17.72 Server Server TCP provider failed to listen on [ aaa.bbb.ccc.444<ipv4> 2020]. Tcp port is already in use.
2007-02-27 12:03:17.75 Server Error: 17182, Severity: 16, State: 1.
2007-02-27 12:03:17.75 Server TDSSNIClient initialization failed with error 0x2740, status code 0xa.
2007-02-27 12:03:17.75 Server Error: 17182, Severity: 16, State: 1.
2007-02-27 12:03:17.75 Server TDSSNIClient initialization failed with error 0x2740, status code 0x1.
2007-02-27 12:03:17.75 Server Error: 17826, Severity: 18, State: 3.
2007-02-27 12:03:17.75 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-02-27 12:03:17.77 Server Error: 17120, Severity: 16, State: 1.
2007-02-27 12:03:17.77 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
View 11 Replies
View Related
May 15, 2008
Hi all,
I have some problem about Reporting Service integrated for SharePoint 2007.
At first, I created 1 user named "User1" under "Domain1". User1 has role "SharePointAdmin" Group and Local Admin Group.
Then I created application pool named "RSAppPool". Its identy was "Domain1User1".
After that, I install Reporting Service and SP2.
Then I config Reporting Service to Integrated Sharepoint Mode below.
Report Server Directory Setting: "ReportServer" in "Default Web Site".
Window Service Identity:
Service Account : "Domain1User1" (Windows Accout)
Web Service Identity:
Report Server: "RSAppPool" (that created above)
Report Manager: Empty
Database Setup:
Database name: Database1 (Server Mode: SharePoint Integrated)
Credential Type : Windows Credentials
Account Name: Domain1User1
After configuration, I reset IIS and test browse to http://servername/ReportServer/ , then there is a Windows Login dialog.
I enter "Domain1User1" and User1's password. But User1 cannot right to access to "ReportServer" virtual directory.
This is error message
You are not authorized to view this page
You do not have permission to view this directory or page using the credentials that you supplied.
HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)
I'm not sure. Where is I config wrong? ....
Please help me.
Thank you very much.
View 1 Replies
View Related
Aug 24, 2006
I have SQL Server 2000 Standard Edition (sp3a) running on a windows 2003 (sp4) Server.
It is a Production Server with 3 NAMED Instances and NO Default Instance.
Does anyone know if I can rerun the SQL Server Install and add a DEFAULT Instance to this box without disrupting the other Named Instances???
View 5 Replies
View Related
Oct 30, 2007
I installed SQL Server 2005 recently on a cluster. I didn't go for the default instance and instead I named the instance option. Now I would like to migrate everything from the named instance to the default instance, which I haven't yet installed.
Is this an easy process? What about the logins and the maintenance plans and jobs? Is there anything else I need to be aware of?
View 1 Replies
View Related
Apr 13, 2007
Hi
I've never had to do this, but when I downloaded the Web Workflow Approvals Starter Kit, it requested that I install the database into a User Instance of .SQLEXPRESS.
Now the problem is, I've installed it onto a default instance, so I was wondering whether you can create a named instance on top of a default instance... and if so, how would you do that?
Cheers
Chris
View 3 Replies
View Related
Jan 9, 2007
Hi Folks,
Is it better to install SQL Server Express Default or install as Named Instance?
What are the pros and conns?
Thanks
View 1 Replies
View Related
Dec 21, 2005
I have just installed SQL Server 2005. I was not given a choice during installation (that I remember seeing anyway) about which drive I wanted to place the default SQL instance on.
It ended up on C: and I needed it on D:.
So my questions are:
Is there a way to move it to D: that is easier than the way you had to go about it in SQL 2000?
Is there a way to do it during setup so I can avoid this in the future?
View 7 Replies
View Related
Jan 29, 2008
Hi,
I have uninstalled and reinstalled several times and I can't get Reporting Services to create the virtual directories in Default Web Site, instead it creates a new web site called Report Server with the virtual directories under that, this Report Server website points to C:Program FilesMicrosoft SQL ServerInetPubwwwroot. Any ideas as to why this happens? My Default Web Site is called Default Website from the initial IIS install , I am on XP Pro SP 2 with IIS 5.1.
This is an issue for me since I don't want to have on another site that doesn't have the aspnet mapings.
I am dumbfounded and can't figure out what to do to make it not do that with the default configuration option checked during install. Should I uninstall and reinstall again and not use the default configuration?
Regards,
Chris
View 3 Replies
View Related
Aug 26, 2014
Plan to setup AG on in both default and named instance of two nodes. Can we do it ?
View 9 Replies
View Related
Nov 14, 2007
Tried to uninstall SQL Server 64-bit on Windows 2003 remotely. All components uninsntalled properly except Reporting Services.
The log file lists the following error -
/*****
ReportingServicesService!library:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: 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)
*******/
Now I cannot see Reporting Services under Add/Remove programs (ARPWrapper.exe /remove). It is also not displayed when using Windows Installer Cleanup Utility (msicuu2.exe). I can start the default instance of RS via Reporting Services Configuration manager and it can also be also started under Windows Services. BTW, the IIS folder structure is under the default website for Reports and ReportServer is present.
So, now how do I go about uninstalling SQL Reporting Services when I cannot see it (as an installed program) without rebuilding the machine ?
Thank you.
Adeaweb
View 1 Replies
View Related
Nov 14, 2007
Tried to uninstall SQL Server 64-bit on Windows 2003 remotely. All components uninsntalled properly except Reporting Services.
The log file lists the following error -
/*****
ReportingServicesService!library:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: 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)
*******/
Now I cannot see Reporting Services under Add/Remove programs (ARPWrapper.exe /remove). It is also not displayed when using Windows Installer Cleanup Utility (msicuu2.exe). I can start the default instance of RS via Reporting Services Configuration manager and it can also be also started under Windows Services. BTW, the IIS folder structure is under the default website for Reports and ReportServer is present.
So, now how do I go about uninstalling SQL Reporting Services when I cannot see it (as an installed program) without rebuilding the machine ?
Thank you.
Adeaweb
View 2 Replies
View Related
Jun 21, 2007
I installed SQL Server 2005 flawlessly yesterday. When login as "sa" through SQL Server Management Studio, I get an error message saying it cannot connect to my PC.
I checked the MSSQL Server Service. It is not started and cannot be started because it's looking for a path that does not exist!.
The folder in question is missing.
C:Program FilesMicrosoft SQL ServerMSSQL
The following folders do exist:
C:Program FilesMicrosoft SQL ServerMSSQL.1
C:Program FilesMicrosoft SQL ServerMSSQL.2
I initially suspected this problem was cause by a previous MSDE 2000 installation.
I uninstalled SQL Server 2005 & MSDE 2000.
I re-installed SQL Server 2005. Same problem.
I executed
http://support.microsoft.com/default.aspx/kb/320873
to make sure all registries are removed and manually deleted C:Program FilesMicrosoft SQL Server��s content
Re-installed SQL Server 2005. Same problem.
I do not know what do in order to get SQL Server 2005 up & running.
All help is greatly appreciated.
Frank
View 2 Replies
View Related
Jun 8, 2007
Dim strCON As String = _
"workstation id=DJI-MAIN;packet size=4096;user id=sa;integrated security=SSPI;data source=DJI-MAIN;persist security info=False;initial catalog=RacingSystem"
Dim cnn1 As New SqlConnection(strCON)
cnn1.Open()
This is the code I have been using to connect to my default instance for 18 months. A recent upgrade to Windows Live onecare now prevents me connecting to the server from the same machine. The following error message is generated:-
Unhandled Exception: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at TrainerReport001.Form1.Form1_Load(Object sender, EventArgs e) in F:#ProjectsStatsOwnerReport001Form1.vb:line 84
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)The program '[3336] TrainerReport001.exe' has exited with code 0 (0x0).
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at TrainerReport001.Form1.Main() in F:#ProjectsStatsOwnerReport001Form1.vb:line 2
If I turn off the onecare firewall I can connect as normal, but this is not a desired option. I have tried enabling port 1433 on the firewall, this does not work either. Any help greatly appreciated, onecare support seems reluctant to help.
TIA
View 4 Replies
View Related
Sep 27, 2015
There was a 2008 SSRS service running on server "abc".
I have a .Net UI that uses the wsdl at [URL] ....
They deployed SSRS 2012 service on a new server "xyz".
DNS points abc to xyz. Nslookup looks right shows both xyz and abc alias to the same IP.
when I try to go to [URL] .... it redirects to xyz as expected for the host name but the HTTP GET /ReportServer is appended with GET /Reports/ReportServer which doesn't exist and I get an 404 error.
I have no admin rights to see anything and I have no idea if it was an inplace upgrade or a new server. I assume it's new since the actual server name changed in nslookup. Why would it append the default virtual directory when it makes the hop to server "xyz"?
View 0 Replies
View Related
Jan 17, 2007
If you were asked to install SQL 2005 on a machine, would u install a default instance or a named one? And why would u choose one over the other?? Also, r there any issues with using a default instance?
Thank you for all your help.
View 6 Replies
View Related
May 17, 2007
On a Server 2k3 x64, I've installed SQL Server 2000 x32 SP4 and SQL Server 2005 x64. When installing both SQL Server 2000 and 2005 on the same server, does each SQL Server have it's own "default instance" or there can only be one "default instance" per server? TIA, Gary.
View 5 Replies
View Related
Dec 6, 2007
Hi there
We have a SSIS run which runs as follows
The master package has a configuration file, specifying the connect strings
The master package passes these connect-strings to the child packages in a variable
Both master package and child packages have connection managers, setup to use localhost. This is done deliberately to be able to test the packages on individual development pc��s.
We do not want to change anything inside the packages when deploying to test, and from test to production. All differences will be in the config files (which are pretty fixed, they very seldom change). That way we can be sure that we can deploy to production without any changes at all.
The package is run from the file system, through a job-schedule.
We experience the following when running on a not default sql-server instance (called dkms5253uedw)
Case 1:
The master package starts by executing three sql-scripts (drop foreign key��s, truncate tables, create foreign key��s). This works fine.
The master package then executes the first child package. We then in the sysdtslog get:
Error - ��cannot connect to database xxx�?
Info - ��package is preparing to get connection string from parent ���?
The child package then executes OK, does all it��s work, and finish. Because there has been an error, the master package then stops with an error.
Case 2:
When we run exactly the same, but with the connection strings in the config file pointing to the default instance (dkms5253), the everything works fine.
Case 3:
When we run exactly the same, again against the dkms5253uedw instance, but now with the exact same databases defined in the default instance, it also works perfect.
Case 4:
When we then stop the sql-server on the default instance, the package faults again, this time with
Error - ��timeout when connect to database xxx�?
Info - ��package is preparing to get connection string from parent ���?
And the continues as in the first case
From all this we conclude, that the child package tries to connect to the database before it knows the connection string it gets passed in the variable from the master package. It therefore tries to connect to the default instance, and this only works if the default instance is running and has the same databases defined. As far as we can see, the child package does no work against the default instance (no logging etc.).
We have tried delayed validation in the packages and in the connection managers, but with the same results (error).
So we are desperately hoping that someone can help us solve this problem.
Thanx,
/Nils M - Copenhagen
View 3 Replies
View Related
Dec 26, 2007
I have a SQL server with SQL 2000 installed and running, in parallel with a recent SQL 2005 installation (viaa named instance on the same box, etc.) - What I would like to do is "decommision" the SQL 2000 installation and "promote" the 2005 named instance to the default- is there a way to do this?
View 2 Replies
View Related
Feb 27, 2008
I will need to use a unique instance name. Do i first need to install SQL 2005 using the Default Instance name, than install using my unique Instance name?
Any help appreciated.
Thanks,
Kerry
View 6 Replies
View Related
May 20, 2004
We installed SQL 7.0 first, then SQL 2000. SQL 7.0 is the default instance.
How can we change the default to SQL 2000?
View 5 Replies
View Related
May 15, 2008
I have SQL server 2005 Developers edition instaled on W2003 only one instance. When I'm trying to install SP2, service pack can't see default instance. I can only upgrace tools and other stuf. I need to upgrade server.
Hava anybody some idea?
Thank you
View 3 Replies
View Related
May 5, 2006
Problem: When the application installs it requires SQL Express
Server 2005. If it does not exist it will install it or
rollback. -> continue installation -> When the form
attempts to locate an SQL Instance on a machine that has not had SQL
server or any components connected before it shows up as
<null>. I need to have access to the server(s) instances in
order to build the application database inside SQL. Am I using
the wrong approach with SQLDMO? Is there adifferent method
to access the installed SQL Express 2005 connection string?
Current code to locate SQL Instances:
try
{
////////////////////////////////////////
// Search and List SQL Server Instances
////////////////////////////////////////
//set cursor to thinking/hourglass
System.Windows.Forms.Cursor.Current =
System.Windows.Forms.Cursors.AppStarting;
//begin
ArrayList aServers = new ArrayList();
SQLDMO.ApplicationClass acServers = new SQLDMO.ApplicationClass();
//loop through the servers found
for (int iServerGroupCount = 1; iServerGroupCount <=
acServers.ServerGroups.Count; iServerGroupCount++)
{
for (int iServerCount = 1; iServerCount <=
acServers.ServerGroups.Item(iServerGroupCount).RegisteredServers.Count;
iServerCount++)
{
aServers.Add(acServers.ServerGroups.Item(iServerGroupCount).RegisteredServers.Item(iServerCount).Name);
}
}
//add the servers to the drop down box
if (aServers.Count < 1)
{
string NotExist = "<No Servers Found>";
cboServers.Items.Add(NotExist);
cboServers.SelectedIndex = 0;
btnSQLDataBaseCheckDB.Enabled = false;
}
else
{
cboServers.Items.AddRange(aServers.ToArray());
//select the first item in the array index to display
cboServers.SelectedIndex = 0;
}
}
catch (Exception ServerException)
{
MessageBox.Show(ServerException.Message);
}
Slightly stuck at the moment with this. Any tips or leads in the right direction would be greatly appreciated.
View 1 Replies
View Related
Aug 18, 2006
Is this the only way to rename the default SQLEXPRESS instance name?
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811
Is there an easier way? I tried going to Register and changing it.. but that didn't seem to do anything.
View 3 Replies
View Related
Nov 13, 2007
Hi,
I am new to this forum and new to SQL, hope someone can help me. TIA
I have SQL 2000 running on the windows 2000 server. The program reside on the E drive and the data reside on the D drive, my system files drive C got corrupted and gave me the blue screen of death, so I had to reload it from back up, but in doing so, my SQL "Local" default instance fail to load after I got the server back up and running. My other instances are running fine except for the Local. Is their a way to bring that back? or do I have to reload SQL default instance ?
Thanks
View 5 Replies
View Related