SQL Express installation

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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


Richard G. Harper said:
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


Alan said:
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.
Click to expand...
Click to expand...
 
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.
 
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


Alan said:
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


Richard G. Harper said:
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


Alan said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top