Hi Duncan,

Bill's way was the right way as well as Gail's. I did it "the Gail's way" and things came back to order.

Thanks a lot to you and all the...

Thanks Bill,

It turned out that changing the path of the "ldf" and "mdf" file was the remedy to my dismay. Having changed their pass from c:\Program files... to where the...

Hi Gail,

This is what i did.

I cleared off the SQLSERVER2005, opened the 2 folders on my disk and tried to drag

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\a_log.ldf

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\a.mdf

To the folder where...

Thanks Gail.

Here is what i do to produce an error message in details:

1. Right "def" database, select "tasks" and then: "restore" and then: "database";

2. At "Restore database - def"...

Thanks. I tried all options:

These are the options:

1. Overwrite the existing database.

Selecting this option, the database "abc" was removed and replaced by the backuped one. I wanted

db: "def" to be...

Thanks a lot,

My problem was resolved by adding a SQL user with a nick other then that of a Windows user login.

A client was successfully installed the same way...

Thanks

I have installed a new server into which i manage to connect but cannot connect from a remote machine. I dont see my old databases, how can i attach to...

I'm at the course of reinstalling my first sql server and i have to make a choice between 2 selctions, a choice which might be the reason for all the...

initially i tried to install a client. I installed one but couldnt see any additional application in "start" menu nor any "exe" program on my disc to start it. So...

I did it. It already is set to automatic. This is the error i get:

"The SQL Server (MSSQLSERVER) service on local Computer started and then stopped. Some services stop automatically...

I'm into a new trouble now... cant connect the local server..

The service: "SQL SERVER MSSQLSERVER" is stopped. From right click menu i select: "start" and i get the following error...

I found the port enable item (called "via") and enabled port o:1433.

At the "server name" i only assigned ip and it didnt work. How do i assign port ?

Hi Jerry,

At "Server name" in "Connect to database engine" i assigned: 192.168.2.103 which is the ip i derived using: "run ipconfig".

I didn't find any place where i could enable port...

OK, this is what i did:

I selected "SQL SERVER Surface Area Configuration from "start" menu

At "Database engine" branch i clicked "remote connection" and signed:

"Local and remote connection"

"Using both TCP/IP and...