I'm not sure but AFAIK user instance is not supported in express version. Instead of file:
Select: MS SQL server
as data source.
Enter:
.\SQLEXPRESS
as server name.
Select your database from drop down.
(or attach db)
Cetin
>Hi Cetin.
>I treid to access the file in another way.
>In Vis Studio, Server Explorer..Data Connections..Add connection
>Specified dara Source as MS Sql Server database File and pointed to my .MDB
> file.
>When I Test Connection... I get following error:
>
>Failed to geneate a user instance of Sql Server duw to a fialure in starting the process for the user instance. The connection will be closed.
>
>
>So... the .MDB is there but it wont alow me set up a connection?
>
>Any ideas.
>
>Gerard
>
>
>
>
>
>>>I have a database that I crated initial with SQL SErver express.
>>>I since have loaded SQL Server and Management Console
>>>How do I open up the Sql Server Express databse with Management Console.
>>>I cant see it in the Databases tree view diagram
>>>
>>>Any helpo appreciated.
>>>Regards,
>>>Gerard
>>
>>Gerard,
>>Did you connect to the SQL express instance? If you didn't touch defaults it's installed as a named instance (machinename\SQLEXPRESS).
>>Connect to server name of SQLEXPRESS. If you have SQL2000 or MSDE or any other with 'default' instance you might have selected that one as the server to connect on startup.
>>Cetin