[MS SQL Server] unable to connect with default instance |
| unable to connect with default instance Posted: 01 Aug 2013 04:10 AM PDT Hi,I have installed sql server 2008r2 enterprise edition on my system.i have got the following errors such as1) unable to connect with an instance name ..some network failure.when I repaired that software master database was not existing and database engine connection problems.so, i uninstall and installed it properly.still iam unable to connect with default instance but i can connect through named instance and local.Could anyone explain me the reason.when i searched on Google,someone mentioned that we don't connect through default instance.As of my knowledge i did connect through that instance before on my frnd's system.please explain me the problem.thank you..!!! |
| changing disk arrays for db's but keeping same drive letters! Posted: 31 Jul 2013 10:08 AM PDT We run in Amazon EC2 but I am sure the principal is the same.Currently the system db's are on C:\ , Logs D:\ , User Data E:\ and TEMPDB F:\.SQL is installed in the default C:\ location.We need to move Logs and Data onto new RAID arrays but keep the same drive letters (so SQL can restart!!)So the plan is:Two new RAID arrays are going to be built and named X: and Q:SQL Service is stopped via SQL Configuration ManagerAll data on D: is copied to X:All data on E: is copied to Q:The original D: will be changed to S:The original E: will be changed to T:X: will be changed to D:Q: will be changed to E:Restart SQL from SQL Configuration ManagerWe will be trying to do a test if we can but thought I would see if anybody see any issues?I can't see anything that needs changing as long as the right files are copied to the right drives and the letters are changed before SQL is restarted.[i]The only thing I can think of is if SQL takes some ID from the underlying disks / volumes etc and recognised the new D:\ is different and spits the dummy!!!![/i]thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment