Available "Initial Catalog" in given Data Source (sql)

[Krys]

In SQL connection string i have to provide Initial Catalog and Data
Source. How can i read available initial catalogues when i know only the
given Data Source (for example "(local)\SQLEXPRESS")?

 

[RobinS]

The InitialCatalog is the name of the database you want to access in your
SQLServer database, like "Northwind" or "pubs".

Robin S.

 

[oscar.acostamontesde]

The InitialCatalog is the name of the database you want to access in your
SQLServer database, like "Northwind" or "pubs".

Robin S.

Try with a query:
SELECT * FROM sys.databases

 

[RobinS]

Try with a query:
SELECT * FROM sys.databases

What if you leave out the InitialCatalog phrase in the connection string?

Have you checked out http://www.connectionstrings.com to see if there's any
info that will help you there?

Robin S.

 

[Rad [Visual C# MVP]]

In SQL connection string i have to provide Initial Catalog and Data
Source. How can i read available initial catalogues when i know only the
given Data Source (for example "(local)\SQLEXPRESS")?

If i'm not wrong if you don't specify an initial calalog SQL server will
connect to the default database of the user specified in the connection
string