sql Server not found

[Irfan Mumtaz]

hi,
i was practising the famous 'northwind database' using vb.net sample
examples. But i am getting an error
'sql server does not exist or access denied'

connectionString = "Server=localhost;DataBase=;Integrated Security=SSPI"
Dim northwindConnection As New SqlConnection(connectionString)
Dim cmd As New SqlCommand(strSQL, northwindConnection)
northwindConnection.Open() //error here

COULD SOMEONE PLEASE ADVICE.
I have got SQL Server 2005 installed in the system and i am using .net 2003

TIA
irfan

[JohnFol]

In your connection string you do not include the database name. You could
try and open the connection using the Server Explorer. This would eliminate
your code. Then, drag the connection onto the designer window and you will
see the correct ConnectionString property.


"Irfan Mumtaz" <sp****@spam.net> wrote in message
news:99**********************************@microsof t.com...

hi,
i was practising the famous 'northwind database' using vb.net sample
examples. But i am getting an error
'sql server does not exist or access denied'

connectionString = "Server=localhost;DataBase=;Integrated Security=SSPI"
Dim northwindConnection As New SqlConnection(connectionString)
Dim cmd As New SqlCommand(strSQL, northwindConnection)
northwindConnection.Open() //error here

COULD SOMEONE PLEASE ADVICE.
I have got SQL Server 2005 installed in the system and i am using .net
2003

TIA
irfan

[Herfried K. Wagner [MVP]]

"Irfan Mumtaz" <sp****@spam.net> schrieb:

i was practising the famous 'northwind database' using vb.net sample
examples. But i am getting an error
'sql server does not exist or access denied'

connectionString = "Server=localhost;DataBase=;Integrated Security=SSPI"

Make sure you are using a complete connection string (at least the database
name is missing). You'll find connection strings for SQL Server at
<URL:http://www.connectionstrings.com/>.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Cor Ligthert]

Irfan

connectionString = "Server=localhost;DataBase=;Integrated Security=SSPI"
Dim northwindConnection As New SqlConnection(connectionString)
Dim cmd As New SqlCommand(strSQL, northwindConnection)
northwindConnection.Open() //error here

In my opinion is there most probably nothing wrong with your Connection
string and it depends for what you are using it, however it does not access
the northwind database, so when your SQL string contains a table for that it
will not be processed.

You can try this one by setting "USE Northwind" as first in your Select
statement.
(Or change the connection string when you don't have to create or to drop
that database what is not likely in this case by just changing
DataBase=Northwind)

However it is in fact not wrong.

I hope this helps,

Cor

[Irfan]

thanks for the replies
I used the server explorer and when i clicked on the Sql Servers, it is
giving me an sql server login dialog box
when i press OK, to enter password and when i press OK it gives
'SQL sever does not exists'.

Thanks again for the response

irfan
"JohnFol" <Ou************@WibbleObbble.Com> wrote in message
news:yK*****************@newsfe2-gui.ntli.net...

In your connection string you do not include the database name. You could
try and open the connection using the Server Explorer. This would
eliminate your code. Then, drag the connection onto the designer window
and you will see the correct ConnectionString property.


"Irfan Mumtaz" <sp****@spam.net> wrote in message
news:99**********************************@microsof t.com...

hi,
i was practising the famous 'northwind database' using vb.net sample
examples. But i am getting an error
'sql server does not exist or access denied'

connectionString = "Server=localhost;DataBase=;Integrated Security=SSPI"
Dim northwindConnection As New SqlConnection(connectionString)
Dim cmd As New SqlCommand(strSQL, northwindConnection)
northwindConnection.Open() //error here

COULD SOMEONE PLEASE ADVICE.
I have got SQL Server 2005 installed in the system and i am using .net
2003

TIA
irfan

[Philip Hristov]

Irfan,

I am using WinXP SP2 and I cannot get connected to SQL Server either.
The solution is to use the name of your computer rather than localhost.
So if your computer is named 'irfan' use irfan. This happends due some
changes in SP2 of XP. I thnk these changes are implemented in SP1 for
Win2003 too.

Regards,

Philip.

[Irfan]

I wrote the DataBase=Northwind, but still it gives the same error. 'Sql
server does not exist'.

BTW, how do i know if the Northwind is installed on the sql server and if it
isnt how do i install it.

TIA

irfan
"Cor Ligthert" <no************@planet.nl> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Irfan

connectionString = "Server=localhost;DataBase=;Integrated Security=SSPI"
Dim northwindConnection As New SqlConnection(connectionString)
Dim cmd As New SqlCommand(strSQL, northwindConnection)
northwindConnection.Open() //error here

In my opinion is there most probably nothing wrong with your Connection
string and it depends for what you are using it, however it does not
access the northwind database, so when your SQL string contains a table
for that it will not be processed.

You can try this one by setting "USE Northwind" as first in your Select
statement.
(Or change the connection string when you don't have to create or to drop
that database what is not likely in this case by just changing
DataBase=Northwind)

However it is in fact not wrong.

I hope this helps,

Cor

[Irfan]

I tried your suggestion also but still the same thing.
BTW, how do i know that northwind is installed on SQL server. If it isnt
then how do i install it

regards,
irfan
"Philip Hristov" <ph********@gmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

Irfan,

I am using WinXP SP2 and I cannot get connected to SQL Server either.
The solution is to use the name of your computer rather than localhost.
So if your computer is named 'irfan' use irfan. This happends due some
changes in SP2 of XP. I thnk these changes are implemented in SP1 for
Win2003 too.

Regards,

Philip.

[Cor Ligthert]

Related to your other question as well

http://www.microsoft.com/downloads/d...displaylang=en

I hope this helps,

Cor

[Philip Hristov]

Irfan, Northwind is included in SQL Server Developer Edition and
Enterprise. It is not included in MSDE 2000.

Philip.