determiningsecurity.blogspot.com
Determining Security: Determine what server i'm running on
http://determiningsecurity.blogspot.com/2012/03/determine-what-server-im-running-on.html
Thursday, March 29, 2012. Determine what server i'm running on. I've generated a report that will need to display different information. Based upon where it is being run. For instance, if the report is executing. On our DVLP server, i need a title to say "Developement". Is there is simple. Way to determine what environment the report is being run in? Wwwsi-intl.com=System.Environment.MachineName. Warning: You'll need to give expression host FullTrust in order to use this. SQL Server Reporting Services.
restoredatabase.blogspot.com
Cannot restore database: Cant Connect anymore
http://restoredatabase.blogspot.com/2012/03/cant-connect-anymore.html
Thursday, March 29, 2012. Need help. I changed my TCP connect port for SQL2005 to port 9601. ON THE SERVER.went into SQL Config manager. SQL 2005 Net Config / TCPIP Properties. Changed TCP Port to 9601. Changed TCP PORT for IP2 section to 9601 where ip is 127.0.0.1. Changed TCP for IPAll section to 9601. Dynamic TCP Port was unchanged and remained blank. Under SQL Config Manager SQL Native Client Network. Changed TCP PORT to 9601. On my laptop went to. SQL Server Config manager. Changed TCP Port to 9601.
sqlreportmanager.blogspot.com
sql report manager: Can't start the SQLAGENT service
http://sqlreportmanager.blogspot.com/2012/03/cant-start-sqlagent-service.html
Tuesday, March 27, 2012. Can't start the SQLAGENT service. I'm tired of trouleshoot one of my sql box that the sqlagent can't started. Here is the message:. SQLServerAgent could not be started (reason: Unable to connect to server '. Local)' SQLServerAgent cannot start). SQLSERVER runs on LocalSystem account with started up type automatic and. Connect to SQL Analyzer: LocalHost, . (period), (local) and blank all. Registry key and MDAC are good safe. BUILTIN Administrators is present and SYSADMIN rights.
sqlreportmanager.blogspot.com
sql report manager: Can't take db offline
http://sqlreportmanager.blogspot.com/2012/03/cant-take-db-offline_29.html
Thursday, March 29, 2012. Can't take db offline. I have an ERP system, and I am try to take the db offline to restore, but it. Will not. Any suggestions. I even rebooted"DBA" DBA@.discussions.microsoft.com wrote in message. News:B16E4BFD-5BC0-4FEE-B53E-53F22D10CFA9@.microsoft.com. I have an ERP system, and I am try to take the db offline to restore, but. Will not. Any suggestions. I even rebooted. Run sp who to see who is currently connected to the database. ALTER DATABASE SET ONLINE. MCT, MCSD, MCDBA.
sqlreportmanager.blogspot.com
sql report manager: Can't Switch to SQL Authentication (Mixed Mode)
http://sqlreportmanager.blogspot.com/2012/03/cant-switch-to-sql-authentication-mixed_29.html
Thursday, March 29, 2012. Can't Switch to SQL Authentication (Mixed Mode). We have a SQL installation that was setup with Windows Authentication. The software we will run requires SQL Authentication (Mixed Mode). When I right click on properties, go to the security tab, click the SQL. Authentication, click on OK and it exits. However, when I go back in. And look at the security tab, it is still set on Windows. Authentication. I tried restarting the SQL services and I get the same. Cant take db offline.
sqlreportmanager.blogspot.com
sql report manager: cant start Trace
http://sqlreportmanager.blogspot.com/2012/03/cant-start-trace.html
Thursday, March 29, 2012. I just created a server side Trace with no filters for testing but Im not. Able to start it. I call sp trace setstatus 1,1 and it says completed. Successfully. It then creates the file it writes too but never writes to it. When I generate activity. Any ideas why? With server side traces, SQL Server writes to the file in 128K chunks, so. You won't see anything written until you have 128K worth of activity. Look at fn trace getinfo to check that your trace really is running. With ...
sqlcannotconnect.blogspot.com
Sql Cannot connect: cannot execute sp/access sp properties using gui
http://sqlcannotconnect.blogspot.com/2012/03/cannot-execute-spaccess-sp-properties_27.html
Tuesday, March 27, 2012. Cannot execute sp/access sp properties using gui. I am not able to right click to execute a stored procedure or right click to access the stored procedure properties using Management Studio. Any ideas on what is causing this or if it is supposed to be this way? Any help is much appreciated. Does the user you are in the database have enought permissions to do that? Thanks for the response Andrea,. I login as sa. Subscribe to: Post Comments (Atom). Sql Server Cannot connect. Cannot...
connectfromaspapp.blogspot.com
connect from ASP app: Cant get LIKE to work
http://connectfromaspapp.blogspot.com/2012/03/cant-get-like-to-work.html
Tuesday, March 27, 2012. Cant get LIKE to work. I have the below procedure that will not work- I must be losing my mind, this is not that difficult - mental roadblock for me. Using SQL Server 2000 to create SP being called by ASP.Net with C# code behind. Stored procedure only returns if input exactly matches L Name. 64;L Name nvarchar(100). SELECT [L Name], [L ID], [C ID], [L Enabled], [L Rank], [L URL]. WHERE L Name LIKE @.L Name. Try it like this:. LIKE '%' @.L Name '%'. Connect from ASP app. Cant get ...
connectfromaspapp.blogspot.com
connect from ASP app: Can't get more than first field to evaluate.
http://connectfromaspapp.blogspot.com/2012/03/cant-get-more-than-first-field-to.html
Thursday, March 29, 2012. Can't get more than first field to evaluate. I am having trouble getting an. Can you provide more details about your problem? I'm afraid you haven't given us enough information to even know what you were doing when you had problems. I can't tell from your description whether you are having this issue with a feature of Team Edition for Database Professionals, or whether you're having some sort of general Visual Studio problem. Can you provide a little more background? Cant get mi...
connectfromaspapp.blogspot.com
connect from ASP app: Can't get mirroring working for all DBs?
http://connectfromaspapp.blogspot.com/2012/03/cant-get-mirroring-working-for-all-dbs.html
Thursday, March 29, 2012. Can't get mirroring working for all DBs? I'm getting the following errors when trying to set up mirroring for a DB. Date 3/2/2007 2:52:06 PM. Log SQL Server (Current - 3/5/2007 8:44:00 AM). Communications to the remote server instance 'TCP:/ SQL2:5022' failed before. Database mirroring was fully started. The ALTER DATABASE command failed. Retry the command when the remote database is started. Date 3/2/2007 2:52:06 PM. Log SQL Server (Current - 3/5/2007 8:44:00 AM). Please help&#...
