SQL Express installation

[Guest]

I have a database application which installs an instance of SQL Express and a
database schema with no actual data. The installation completes and I can
see that SQL and the database have bee installed in C:\Program Files but when
I try to run the application I could not login to the database - the error is
that the user (Windows authorization) is not permitted to login.

I downloaded and installed SQL management studio express in hopes that I
would be able to see what logins had been setup for the database. When I
started SQL management studio it could not find any database engine instance
to connect to even though I know one exists.

This all works on an XP Pro system so I think I have missed something
regarding all the new permissions issues with Vista.

What have I done wrong? Thanks.

 

[Richard G. Harper]

Ah - did you note that it is not supported on Vista?

--
Richard G. Harper [MVP Shell/User] (e-mail address removed)
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm

 

[Guest]

What's not supported on Vista?

The application source says their application will operate on Vista.

I assume SQL Express and SQL Management Studio will.

--
Alan Bower

Ah - did you note that it is not supported on Vista?

--
Richard G. Harper [MVP Shell/User] (e-mail address removed)
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm

I have a database application which installs an instance of SQL Express and
a
database schema with no actual data. The installation completes and I can
see that SQL and the database have bee installed in C:\Program Files but
when
I try to run the application I could not login to the database - the error
is
that the user (Windows authorization) is not permitted to login.

I downloaded and installed SQL management studio express in hopes that I
would be able to see what logins had been setup for the database. When I
started SQL management studio it could not find any database engine
instance
to connect to even though I know one exists.

This all works on an XP Pro system so I think I have missed something
regarding all the new permissions issues with Vista.

What have I done wrong? Thanks.

 

[Carey Frisch [MVP]]

For your application to work under Vista, you need the SP1
version of SQL Express, not the original one.

Microsoft SQL Server 2005 Express Edition Service Pack 1
http://www.microsoft.com/downloads/...1F-8F44-4DB6-B542-4A4B869C2FF1&displaylang=en

--
Carey Frisch
Microsoft MVP
Windows Shell/User

---------------------------------------------------------------

I have a database application which installs an instance of SQL Express and a
database schema with no actual data. The installation completes and I can
see that SQL and the database have bee installed in C:\Program Files but when
I try to run the application I could not login to the database - the error is
that the user (Windows authorization) is not permitted to login.

I downloaded and installed SQL management studio express in hopes that I
would be able to see what logins had been setup for the database. When I
started SQL management studio it could not find any database engine instance
to connect to even though I know one exists.

This all works on an XP Pro system so I think I have missed something
regarding all the new permissions issues with Vista.

What have I done wrong? Thanks.

 

[Richard G. Harper]

I checked the download page and the SQL Server Management Studio Express
Edition says it only supports Windows 2000 SP4, Windows XP SP2 and Windows
Server 2003 SP1 - no Vista support listed.

--
Richard G. Harper [MVP Shell/User] (e-mail address removed)
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm

What's not supported on Vista?

The application source says their application will operate on Vista.

I assume SQL Express and SQL Management Studio will.

--
Alan Bower

Ah - did you note that it is not supported on Vista?

--
Richard G. Harper [MVP Shell/User] (e-mail address removed)
* NEW! Catch my blog ... http://msmvps.com/blogs/rgharper/
* PLEASE post all messages and replies in the newsgroups
* The Website - http://rgharper.mvps.org/
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm

I have a database application which installs an instance of SQL Express
and
a
database schema with no actual data. The installation completes and I
can
see that SQL and the database have bee installed in C:\Program Files
but
when
I try to run the application I could not login to the database - the
error
is
that the user (Windows authorization) is not permitted to login.

I downloaded and installed SQL management studio express in hopes that
I
would be able to see what logins had been setup for the database. When
I
started SQL management studio it could not find any database engine
instance
to connect to even though I know one exists.

This all works on an XP Pro system so I think I have missed something
regarding all the new permissions issues with Vista.

What have I done wrong? Thanks.