Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dallr
Yak Posting Veteran
87 Posts |
 Posted - 2006-12-04 : 19:10:10
|
| Hey guys i have installed SQL Server Express and getting a problem. Every time I use the runcommand and enter sqlcmd. It opens the window but then I cannot enter any information into it. And after a while the window just closes. Anyone know the reason for this?Dallr |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-04 : 23:33:33
|
In the Run command, type CMD to go to command window and then at command prompt type SQLCMD /? to see the options.Or else, type the following in RUN window:SQLCMD -S server-name -U user-name -P password Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
Dallr
Yak Posting Veteran
87 Posts |
Posted - 2006-12-06 : 12:50:34
|
| Thanks for your assistance Harsh and your interest in my problem. The sqlcmd /? is something i defintely need to remember. However, I still have my inital problem. What i did now was open the run command by typing cmd and when use the sqlcmd with the -s switch (sqlcmd -s MyServerName). By doing this i get a message telling me the SQL server does not allow remove connections. But I have TCP and Name Pipes enable, the firewall enabled and sql server browser service is set to automatic. Do you have any other suggestions. |
|
|
|
Dallr
Yak Posting Veteran
87 Posts |
Posted - 2006-12-06 : 13:09:04
|
| I have found out what was going on. Here are the steps for anyone else in the future.1. Click Start and then go to the Run command and enter CMD.2. Type sqlcmd -S .\YourServerName -E 3. In point 2 above -E is optional and used for windows authentication. I also learned that sqlcmd -? gives the same information as sqlcmd /? Thanks again Dallr |
|
|
|
|
|
|
sqlcmd opens blank and then just closes.