Hi , yeh I have seen this, and pretty weird.  Solution in my case was to reboot server and all has worked fine since.  Problem originally occurred after I tried...

Hi, yeh just done a cluster install but 32bit sql on 32bit o/s so your problem may be different. 

 I had heaps of issues with creation of the second instance.  Firstly...

A simple way is via Enterprise Manager, list database then list tables in the database.  From here you can right click on the table and select 'all tasks' then 'generate...

These MS articles should answer all your questions

http://support.microsoft.com/kb/263556/EN-US/

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886&sd=tech

What version of Windows?

Hiya, pretty straightforward if you want to use std sql agent alert mechanism.

Create a new alert and select error number 18456.

select all databases or limit only to those you want...

Both instances are on the same vmware server.  Aliasing may be an option but why is SQL refusing to dynamically pass connections to the dynamic port for each listener?  By...

I would have said the same up until a recent problem has forced us to use named pipes.  Issues can occur using Named instances of sql server and options are...

Hi agree with previous post, you can find more info by looking in the dumpfile that you will find in the sql server error log directory c:\program files\mssql\LOG or whatever...

You could also look at the windows event log which should contain an entry for each failure, not sure if it indicates workstation.  As previously mentioned you could create a...

No problem, I might try altering a rep server environment here and see if it logs the new DB server location, I will advise if I find anything.

Regards from Australia

Derek

Sorry should have mentioned that the .log file extracted from the CAB is RSMSI0.log, do a find on RSDATABASESERVER  and this points to db server.

You can find the SQL server instance hosting the meta databases by checking the install logs on each reporting server.  These by default live in C:\Program Files\Microsoft SQL Server\80\RS Setup...

Thanks will check the link.  I agree it should be a concious decision but to date we have used vanilla defaults on install, both Win2000 and Win2003 have exact same...

Thanks, but this is not adhoc as it occurs every time.  Collation is different after install on win2k vs win2003, different servers etc. I agree now that its a smart...