enterprise manager problem

Question

Post reply

enterprise manager problem

newbie_dev

SSCommitted

Points: 1916
More actions
September 24, 2008 at 8:15 am

#194054

Hi
I'm trying to learn stmh about full text indexing and I'm trying to work with enterprise manager but I cannot connect to my database
I get the following error:
A connection could not be established to xyz.
Reason: Cannot generate SSPI context
Please verify SQL SERVER is running and check your SQL SERVER registration properties and try again
Can you help me?
Thanks

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

Can you ping the server that SQL server is installed?

Have you enabled remote connections?

Have you enabled SQL browser on the server?

newbie_dev SSCommitted Points: 1916 More actions · Answer 2

Everything is on my computer.I'm not trying to connect to another computer...

The server is started....I'm using SSMS in the same time....

steveb. SSC-Forever Points: 46733 More actions · Answer 3

what connection string are you using?

is sql browser enabled?

newbie_dev SSCommitted Points: 1916 More actions · Answer 4

yes it's enabled. it starts automatic

I don't uderstand your question about the connection string ...

I'm opening enterprise manager from Start -> M sql server->... intialy to enable full text search ...and to do other things...for testing.

So ... if I'm not understanding please be more specific...

Thanks

steveb. SSC-Forever Points: 46733 More actions · Answer 5

I am just trying find out exactly what the problem is,

So you are able to connect to the database?

Or are you simply not able to create FTI ?

the more information you provide the easier it is for someone to help you out..

newbie_dev SSCommitted Points: 1916 More actions · Answer 6

So

I'm reading an article about full text indexing , and the advice of the autor and the examples are made using SQL Server Enterprise Manager.

So I tryied to used. I open SQL Server Enterprise Manager(Start - Programs - M SQL Server - Enterprise Manager).It opened. I have my local server in the group but when I click or when I try to connect I get the error I write above .

The server is running...I'm writing queries in SSMS in the same time ...I used Windows Authentication...

I don't know what I can tell you.

For instance SS Configuration Manager "works". I don't have a problem connecting or anything else...

Rootman SSCrazy Points: 2641 More actions · Answer 7

Which vresion of SQL server are you running? Are you perhaps trying to connect to a SQL 2005 or 2008 version in Enterprise Manager?

newbie_dev SSCommitted Points: 1916 More actions · Answer 8

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Service Pack 2 Developer Edition

Rootman SSCrazy Points: 2641 More actions · Answer 9

Right there is your problem then. You cannot connnect to sql 2005 instance via Enterprise Manager.

You will either need to create a 2000 version of your db, or work in SMS.

HTH

PS I think you can use Query Analyser to connect to a SQL2005 instance though

newbie_dev SSCommitted Points: 1916 More actions · Answer 10

I think I'm a little stupid....:D

In Start I have SQL Server 2005 and SQL Server ....

Enterprise Manager is in SQL Server and Config Manager is in SQL Server 2005.

I tried accessing Profiler, and the one from SQL Server 2005 is working, on the other...it's not.

Thank for your responses... I will try using SMSS

Steve Jones - SSC Editor SSC Guru Points: 736254 More actions · Answer 11

I'm not sure what you mean. Is it that Profiler in the SQL Server program group (for SQL Server 2000) isn't working?

It doesn't matter. You can use the SS2K5 version to trace SQL 2000 servers.

newbie_dev SSCommitted Points: 1916 More actions · Answer 12

I've said before that Config Manager is working.But C Manager was in SQL Server 2005 not in SQL Server where was E Manager, so it was irrelevant.

So for Full text indexing in SS 2005 you have to use SMSS.

Ok

Thanks