how to start SQL Server 2005 Workgroup Edition

Hot Topic

suggestions
linked reports RS 2005
Incremental processing and aggregations
SSIS: First Time Script Component
Database Tuning Advisor DTA Import Session Results?
The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid
Copying database using "Copy Database"
Stuck between "Failed to generate user instance" and "An attempt to attach...failed"
SSIS Error message
Problem when failing over to mirrored database

SQL Server

locked out of sql server management studio
sqlcmd with trusted connection and IP address or fully qualified hostname
Cannot add SQL database in Visual Studio
Dynamic report with several datasources
Won't select rows with null field values
Calculated field question sum of a product rather then the product of sums
High availability for Database Mirroring
Multi level document map
how to loop through several excel sheets in a file in integration services
Creating process doing specific job periodically

how to start SQL Server 2005 Workgroup Edition

i have SQL Server 2005 Workgroup Edition

how to connect to it from vb.net 2005 because i try but no use

thanks in advance.




Answer this question

how to start SQL Server 2005 Workgroup Edition

  • TimClark

    hi,

    depending on how you installed the SQL Server instance, you have to provide the appropriate name..

    for a "default" instance, it's name will be (Local) or ComputerName;

    for a "named" instance, you have to add the InstanceName to the above definition, becoming something like ComputerName\InstanceName

    you can see the actual installed instances in several ways.. check the SQL Server Configuration Manager, in the SQL Server 2005 Services node... you should see something like
    SQL Server (MSSQLSERVER) <--- this is a default instance

    SQL Server (other names, like SQLEXPRESS or th like) <--- this is a named instance..

    or you can access your Microsoft Management Console applet to manage Windows services, and you should find

    SQL Server (MSSQLSERVER) <--- this is a default instance

    SQL Server (other names, like SQLEXPRESS or th like) <--- this is a named instance..

    or you can inspect the Windows registry, but the above should suffice..

    regards



  • fishy_swa

    thanks for reply

    ok now i wanna connect so what is the server name

    thanks



  • Rhubarb

    hi,

    if the server is up and running, you can connect your application via a "traditional" connection string... see http://www.connectionstrings.com/ for connection string samples..

    regards



  • how to start SQL Server 2005 Workgroup Edition
Answer this question