I've only seen instance(s) access databases on that instance. Can multiple instances access databases on other instances, in the old versions or in R2 of sql server?
View Complete Post
Im using Enterprise library 5.0I have a scenario, where I have to access two
different databases in my application.Basically this application is a
webservice,delployed on my local for testing purpose.I'm trying to access
this web method from diffent windows application, default connection works fine
but the other database throw's exception.Problem is only my
defaultDatabase is works fine, if I change defaultDatabase="MYCON1" with
"MYCON2" it works fine, if I try to access the other database which is not
default, throws exception.<dataConfiguration defaultDatabase="MYCON1"
connectionString="Data Source=server1;Initial Catalog=dbName1;User
I have tried dozens of changes and modifications to many settings as I will outilne here and all to no avail.
The short answer here though is that I uninstalled SQL Sever Express 2008 R2 and went back to the "NON" 2008 R2 and got things working. But like the fool I am wanted to run on the more current rev and updated again, all problems returned....
Win Server 2003 R2 SP2
SQL SERVER EXPRESS 2009 R2
VWD2008 Express (removed)
SQL Server Express 2008
I was orginally getting this message after updating to SQL Sever Express 2008 R2, I removed VWD 2008 Express from the web server, no good, then uninstalled SQL Server 2008 Express R2 and reinstalled SQL Server 2008 Express. worked but had issues, couldn't install MGTM Studio. Then I removed SQL 2008, cleaned folders and reg. Reloaded SQL Server 2008 Express, still flaky, couldn't get the Management Studio to install. So I removed it again and used the Web Platform Installer, which worked but loaded 2008 R2 again. Which brought back the message.
Failed to genera
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.
MSDN Magazine June 2000
Sharepoint server 2007 and remote sql 2000 SP4 database, after ShraPoint server crash only content databases are available and intact. Trying to restore from backup fail, stsadm -o restore says that not valid backup is available on path. How to get access
to available content database using a new installation with same server name, ip address and partitions configuration. How to recover site with content databases information.
Regards, thanks for help.
I just installed SQL Server 2008 Management studio Express on my Vista machine. i tried connecting to local machine using :.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpressnothing is working, getting this error:-----------------------------Cannot
connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific
error occurred while establishing a connection to SQL Server. The server
was not found or was not accessible. Verify that the instance name is
correct and that SQL Server is configured to allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating