Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can not see the database
Message
General information
Forum:
Microsoft SQL Server
Category:
Security
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01300594
Message ID:
01300940
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
>>>When you get Login dialog just open Server name combo. There you should have all instances of your server + all servers SSMS found.
>>
>>It gives me 2 servers. One I can connect using Windows Authentication, another I can not.
>>
>>>Also if you open SQL Server Configuration Manager there you could see what services you have. On my office computer i have:
>>>SQL Server (MSSQLSERVER)
>>>SQL Server (SQLSERVEREXPRESS) (or something like that)
>>>
>>>Right click on every instance and see all properties for it.
>>
>>If I found my database files in one directory, how can I make them available in the instance I'm running this?
>>
>>Thanks again.
>
>We're getting 'Timeout expired' trying to use test server database from the ASP.NET application. Do you know what can I adjust?
>
>Thanks again.

In VFP we have SQLSETPROP(connectionm "QueryTimeOut",number of seconds) But in ASP, I don't know.
If you want to set it for whole server, run SSMS and right click on Server. Properties->Advanced->Query Wait. I never tried this though.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform