Search results

I have moved these sites over to MS SQL and I am still getting this error daily. They were also put in seperate application pools but these seem to expire. Here's the error: Error Number: -2147012894 Error Description: The operation timed out Any other ideas on how to resolve this issue...

Hello, Good to know this for future reference when using MS SQL 2005. Looking at EMS SQL Manager 2008, it is not cheap ($300 +) and the Enterprise Manager in Hsphere is useless. Does the free EMS SQL Manager 2008 Lite for SQL Server work well and provide a good amount of functionality? IS...

Hello, Here's another question about MS SQL that I could use help with. I'm a bit green when it comes to MS SQL so any help is appreciated. I would like to encrypt data in MS SQL. My Jodo account is using MSSQL9 which is 2000. I'm running MS SQL Developer Editions 2005. What is the...

Hey Stephen, Thanks for the vote of confidence! I don't believe this is an issue with the username and password either. I'm assuming my issue is with how I am setting up the user accounts. What I want is a DB login and user that does not have all the permissions of the main DB login/admin...

Hey Stephen, Thanks for the reply... Right... This has not been my experience. I created a user in Hsphere and received permission issues when using ADO. Maybe I am not using the right connections string? Here is the error: Microsoft OLE DB Provider for SQL Server error '80040e4d' Login...

Hey Stephen, Thanks for the reply. Forgive my lack of understanding. I am still a bit green when it comes to MS SQL server. Let me see if I can clarify further. My understanding is that it is better not to use the Hsphere SQL Database login for ADO connections. I have tried using a Hsphere...

Thanks Stephen I may ask for this but not unless I can use a MS SQL user for connection strings in the code. Any idea why the MS SQL users created in Hsphere will not work in connections strings in code?

Hey TechSavy, How about something like the following: SELECT Date,SUM(Rainfall) FROM table GROUP BY Date HAVING SUM(Rainfall)>2.4

Hey Cdog, Thanks for these instructions. I finally was able to duplicate the DB using the Tasks > Generate scripts, I think. I say "I think" because I had a support ticket in and tried the Jodo restore tool at the same time so it could have been one of the other items finally worked. But, I...

Ok, not sure if Jodo has made any changes to my login but I can script to after removing the following from the above script: CONSTRAINT [PK_tblmain] PRIMARY KEY CLUSTERED ( [tblmainID] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] Stephen, I would assume that I am the DBO or at least admin...

Hey Stepehn, Thanks for the quick reply. I swear I was able to Script Database As last week when I was trying to duplicate a database. Should I not be able to use Script DB As? I Understand there isn't anything that can be done server side for SQL injection attacks, but I'm really confused why...

Another update, I can import and export data, open tables and delete records, and generally do anything other than create tables, Script Database As, and Generate Scripts. My web sites are still collecting and displaying data from MS SQL as well. IS this a Schema issue? What would cause this...

I seem to be having the same issues! http://support.jodohost.com/showthread.php?t=12265

Hey Stephen, I'm having issues with my login on MSSQL9. You mentioned that you have tools to help find vulnerable pages. I've used Nikto and tried to sanitize any inputs but I'm wondering if this is causing my issues. What tools do you have that might help? Any idea why I'm having the issues...

Hello, For the last couple of days I have had issues working with MS SQL via SMS. I am trying to create a table either on the server or locally using SMS 2005. When I try "Script Database As" on MSSQL9 I get the error below. I have changed my the user and db to user_db...

Another update... I now tried deleting and recreating the DB via Hsphere, then restoring to the new DB name. Same issue "SQL Error Occurred". I am also trying "Generate Scripts" on the original DB via SMS and I get a script file that looks like it will create the DB for me, including the...

Ok, so I think on e of the issue I was having with restoring the current DB to the new DB was that I was using a .BAK file created locally using SMS 2005 after adding some columns. So I downloaded a backup from Jodo and tried to restore to the new DB using the Jodo SQL web utility. Now instead...

Stephen, thanks for the reply. Yes I tried the http://mssql9.xxx.com/mssql/Restore.aspx and get the following error: MSSQL 2005 backup file was used. Plese use a correct backup file. Technically I'm not trying to restore, I need to copy. I did try using the following SQL query to restore...

Thanks again for trying to help cdog. I just tried to import the data again and the data and structure is imported but the primary keys, etc are missing. I'm really in a bind here as I need to bring this development DB online ASAP. I've got a support ticket in but they are having problems...

Hey cdog, Thanks for the reply. Yes, I tried the import/export feature but it only imports the data and tables. All the primary keys, triggers, etc are lost. Is this normal? I really just need to copy a DB that is already at Jodo and make some minor customizations to duplicate an...