If you want to migrate users, logins, jobs, you have to backup and restore system databases. Some things you cannot migrate. If you have DTS packages jobs, you cannot migrate them. There...

I checked database server from my local machine using telnet and it connects to port 1433. I tried to connect from  application server on DMZ and it cannot  open that port. So port...

When I type "telnet ip_address 1433", it connects and i see empty screen.

When I type "telnet ip_address 1434", I get "Could not open connection to the host on port 1434 connection failed". What...

Oh well, didn't work. In the surface area configuration is set to "Using TCP/IP only", so it's OK here. Maybe ports should be opened  in the firewall somehow or something....

Do you mean I should check if TCP/IP is enabled in SQL Server Surface Area Configuration for Services and Connections?

Good Luck!

Hi,

I just took a week class on SQL Server 2005 and this is what I learned. There are four methods to move databases around :

1. Script objects and migrate data

2....

Well.. developer's world is better. You don't have to worry about  servers, networks, users, permissions, databases. All you have to do is write a nit code, think, be creative. The...

Andras,

I'm also worried about space, that backups will fill up the disk and put server down. And I worry that something will go wrong and I will not be able...

I tried that and unfortunately it didn't work. OrderDetails and OrderDetailChoices tables do not have primary keys to group by. I tried in the reporting services, didn't work. I didn't...

SQL Server 2005 is a pain in the ass. Physical server, the machine went down again for some reason, nobody can figure out why, it's the third time today. When...

Thanks, it worked!

Thanks, I'll do that!

And where/how to check a group policy? I am sure there is no start up script, nobody is smart enough to do so

Yes and it was set to Windows only auth. Somehow when server went down, it resetted itself to Windows only. How is it possible? Now each time it goes down,...