Re: Cannot connect to SQL express database ????

Did you stop and restart SQL Server 2005 Express Edition after setting 1500 as the fixed port?
Are you attempting to connect to the Express Edition by name in the format computer_name\SQLExpress ?
Is the SQL Server Browser service running?
Can you connect to the Express Edition by the port number using computer_name,1500 or by IP address in the format 127.025.144.315,1500 ?
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F1AB79D1-899E-40C6-BE14-21D0305C36CA@xxxxxxxxxxxxxxxx
Thnaks for your reply...
I have check seetings as describe in this link.

What happen is that I have SQL express install on a Vista machine
Then I set use of tcp port from the surface configuration tool and set port
to 1500
From a simple remote machine running w2000, I try to establish an ODBC
connection to my VIsta machine where SQL express is installed.
For that I have install on my 2000 machine the SQL native client for 2005
and try to define a DSN name but when trying to connect...no way...

Any ideas ?

regards
serge
"Rick Byham, (MSFT)" wrote:

Probably either the SQL Server Express instance has not enabled remote
connections, or a firewall is blocking the connection.
Run through the short tutorial in Books Online and see if that solves the
problem. The tutorial is also online at
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Note that lesson 2 is
Connecting from Another Computer.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"calderara" <calderara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:067F10D8-72B1-4858-AE9F-E5EEF213BEF1@xxxxxxxxxxxxxxxx
> Dear all,
>
> I have setup a database under SQLexpress 2005 which is install on a > Vista
> OS.
> I can manage without any problem my database from the VIsta > workstation.
>
> Then on an other PC, I am trying to create a connection to that databse
> with
> .NET 1.1, but no luck
>
> I ma using similar conenction string as for an SQL server databse > excpet
> that Server="MyWorkStationName\SQLEXPRESS".
>
> I have place the conenctionstring in a config file as follow :
>
>
> "Database=Line_Config;Server=MyWorkStationName\SQLEXPRESS;uid=rptuser;Pwd=reporting"
>
> What is wrong that prebvent me from connection to database ?
>
> Is it possible to connect to an SQLExpress database located on an other > PC
> ?
>
> thnaks for help
> regards
> serge


.

Relevant Pages

  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)
  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)