405 reputation
310
bio website bogdandotnet.blogspot.com
location Ukraine
age 39
visits member for 5 years, 1 month
seen Jan 30 at 15:18
Experienced .NET developer and project Manager. Now working for EPAM Systems (www.epam.com)

Jan
20
comment How to profile which SQL server a .NET application tries to connect
it was a wierd case... app was assuming by default in case of unproper configuration that a local SQL Express exist and was trying to connect there.
Dec
14
comment Keeping SQL Express below 4gb?
I dont think file fragmentation will be an issue with databases of less then 4 Gb size is located on 120 Gb drive. File fragmentaion happen when file is growing, not when shrinking. What is more important is index (not file!) fragmentation. Read this article - sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases perhaps you will want to see if your indexes are defragmented and rebuild them after the database shrink.
Jul
27
comment SQL Server Error: 18456, Severity: 14, State: 16 creating SharePoint SSO database
can you run SQL profiler and see what sql command causes the error? perhaps it will give you more details on error context
Jul
20
comment MSSQL 2005 Service Broker failing to start
what was the history of the databases on that server ? did you transefered databases (including any of system databases) from another computer/domain (using backup restore or detach/attach)?
Jul
17
comment How do I configure ASP.NET to use SQL Server 2008?
You should enable SQL Browser service. See in start menu Configuration Tools, SQL Server Surface Area, Configuration of Services, SQL Server Browser, Startup type = automatic, Start. Also in Remote Connections enable TCP/IP or Named pipes, or both. Also, if other users will connect on TCP/IP you should allow connection to 1433 port in windows firewall. Search Serverfault - there should be a lot of answered questions related to SQL Browser service or TCP/IP configuration
Jul
6
comment Is using the /3GB statup switch in Windows 2008 x64 only running Sql Server 2008 x64, a good thing?
I suggest you also to read answers to the similar question serverfault.com/questions/27352/…
Jul
2
comment How to run SQL Server 2005 and 2008 on the same box?
I recommend you to update the text of the question... If anybody else will read it, chances are that he/she will never go thru all these comments.. Seems that it is not related to SQL Server, rather to router configuration, so I can't help you much, sorry.
Jul
2
comment How to run SQL Server 2005 and 2008 on the same box?
ummm... you wrote about "another machine" not "another network". ok, so named pipes will not work for you, and you have only TCP/IP. But, I suggest a good way to isolate your problem - try to disable named pipes, leave only TCP/IP and connect from LOCAL NETWORK but from another computer in the same network. if it works in local network then problem is in only in your router configuration.
Jul
2
comment How to run SQL Server 2005 and 2008 on the same box?
I don't understand your question "??? how do i browse from the remote computer ???" - read my comment again. In Login window you select in Server Name combo box <Browse for more...> then there you see a tab "Network servers" and you browse the entire local network for all SQL instances. What is the question?
Jul
2
comment How to run SQL Server 2005 and 2008 on the same box?
I do recommend as the first step to switch the entire firewall off temporary and check, is this really a problem with firewall.
Jul
2
comment How to run SQL Server 2005 and 2008 on the same box?
From MSDN "When SQL Server 2000 and SQL Server 2005 clients request SQL Server resources, the client network library sends a UDP message to the server using port 1434. SQL Server Browser responds with the TCP/IP port or named pipe of the requested instance. The network library on the client application then completes the connection by sending a request to the server using the port or named pipe of the desired instance." - so, in your case, 1444 and 1434 ports should be opened in firewall...
Jul
2
comment How to run SQL Server 2005 and 2008 on the same box?
you write "don't seem to find a way to specify a port number when connecting to named instance via MS SQL Management Studio" you cannot provide it in Studio, because SQL Browser provides such details for clients. Could you in the New Connection -> Login screen select Server Name, <Browse for more...> Can you see both instances in server browser?
Jul
1
comment Configuring SQL server 2005 enterprise edition
I suppose the other authors already answered your question. I just wonder why to install Enterprice on local computer, if Developer Edition has all features of Enterprise and the license cost is significantly lower ?
Jun
19
comment How to best diagnose Failure in loading assembly errors
Do you have this only on your front-end web farm ? Or I better ask is it possible to try reproducing the issue on another server (where you will have full admin rights and can use any tools)? Is it possible that you take an image of you web farm, and load it in VirtualPC or WMWare on a workstation?
Jun
18
comment Are there any drawbacks of “/3Gb” switch in boot.ini for 32bit Windows?
Thanks to all who answered, all posts are very informative and there are lot of considerations to be taken into account. I also read some documentation and noticed that for MS SQL Server you dont need this even for 32 bit systems, you could enable Address Windowing Extensions (AWE) technet.microsoft.com/en-us/library/ms190673.aspx