Showing posts with label evaluation. Show all posts
Showing posts with label evaluation. Show all posts

Friday, March 30, 2012

No Management Studio in 2005 Enterprise Edition

I have installed SQL Server 2005 Enterprise Edition Evaluation on my

machine and Management Studio or Enterprise Manager is not present. Do

i need to perform extra task or did i do sth wrong when installing this.

Thanks for your attention.

It's more likely that you did not install the client components
When you setup program, at one stage wou have choice to check the components you want to install
Client components are grouped under the name orf workstation or something similar (Sorry I don't remeber the exact name))

sql

Saturday, February 25, 2012

Newbie: SQL Server connection, help needed

Needs some help, I recently recieved an evaluation copy of SQL Server2000
and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
Server to
service pack3 and installed .net as well. I am still having connection
problems. I am
trying to setup an ODBC connection from another XP and win2000 machines.
Connection failed:
SQLState: '28000'
SQL Server Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'rick'. Reason: Not associated with a trusted SQL Server connection.
I have already checked for Windows Authentication being enabled on the
server.
Of course the ODBC connection works locally.
'preciate any help
thanks
Hi
"Not associated with a trusted SQL Server connection" means that your
credentials passed do not match those with rights in the databases.
You need an NT Domain to use trusted security (except on the local machine).
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rick" <rmsingh@.rogers.com> wrote in message
news:eHqmDTdEFHA.392@.TK2MSFTNGP14.phx.gbl...
> Needs some help, I recently recieved an evaluation copy of SQL Server2000
> and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
> Server to
> service pack3 and installed .net as well. I am still having connection
> problems. I am
> trying to setup an ODBC connection from another XP and win2000 machines.
> Connection failed:
> SQLState: '28000'
> SQL Server Error 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'rick'. Reason: Not associated with a trusted SQL Server connection.
> I have already checked for Windows Authentication being enabled on the
> server.
> Of course the ODBC connection works locally.
> 'preciate any help
> thanks
>

Newbie: SQL Server connection, help needed

Needs some help, I recently recieved an evaluation copy of SQL Server2000
and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
Server to
service pack3 and installed .net as well. I am still having connection
problems. I am
trying to setup an ODBC connection from another XP and win2000 machines.
Connection failed:
SQLState: '28000'
SQL Server Error 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for
user
'rick'. Reason: Not associated with a trusted SQL Server connection.
I have already checked for Windows Authentication being enabled on the
server.
Of course the ODBC connection works locally.
'preciate any help
thanksHi
"Not associated with a trusted SQL Server connection" means that your
credentials passed do not match those with rights in the databases.
You need an NT Domain to use trusted security (except on the local machine).
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rick" <rmsingh@.rogers.com> wrote in message
news:eHqmDTdEFHA.392@.TK2MSFTNGP14.phx.gbl...
> Needs some help, I recently recieved an evaluation copy of SQL Server2000
> and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
> Server to
> service pack3 and installed .net as well. I am still having connection
> problems. I am
> trying to setup an ODBC connection from another XP and win2000 machines.
> Connection failed:
> SQLState: '28000'
> SQL Server Error 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed fo
r user
> 'rick'. Reason: Not associated with a trusted SQL Server connection.
> I have already checked for Windows Authentication being enabled on the
> server.
> Of course the ODBC connection works locally.
> 'preciate any help
> thanks
>