Design Tools / Sql Server Mgt Tools Cause Login Fail
Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
View Complete Forum Thread with Replies
Related Forum Messages:
Backup Strategy - SQL2005 Tools Versus 3rd Party Tools
I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?
View Replies !
Tools For Database Design....
We have several developers that design DBs using the SQL 2002005 Database designer. What tools, of reasonable price (< $!000 ?) are availabe today for database designers. IA, Barkingdog
View Replies !
[MS Design Tools] - Catastrophic Failure
I am receiving the error outlined in the post title whenever I attempt to query or manipulate tables within Enterprise Manager. I am able to function normally (or as normal as a Teddy functions) using QA, only EM seems affected, and only on this machine. I think the problem coincides with an installation of the SQL 2008 CTP and management tools. I'm not sure exactly where to look to fix this. Here is a screenshot of the dialog I"m receiving: http://i184.photobucket.com/albums/x59/mn_teddy/work%20stuffs/em_error.jpg Any thoughts?
View Replies !
Ms Design Tools Invalid Class String - Error
ms design tools invalid class string - error i use windows XP WITH SP-2 , SQL SERVER 2000 WITH SERVICE PACK 4, VISUAL STUDIO 6 WITH SP5, .NET 2.0, VS2005. I AM CURRENTLY GETTING THE ERROR WHEN I USE ENTERPRISE MANAGER IN SQL SERVER 2000. WHEN I SELECT A PARTICULAR DATABASE AND A TABLE, AND WHEN I SELECT THE DATABASE DIAGRAM AND TRY TO CREATE A NEW DATABASE DIAGRAM, I GET THE ABOVE ERROR
View Replies !
Tools For Design Recovery (reengineering) Of C# Source Code With Embedded Sql Statements ?
Wonder if somebody know if it exist som tools that makes it possible to geta graphical overview of relationships between C# source code components andtheir's interaction with the database tables/elemts (E.g SQL serverdatabase)A typecial rewengineering tool to get a grasp of a system with manycomponents acessing multiple tables in a rdm system.A tool that parses the C# code for sql/(databse interaction) and presentsthe interaction grahical in som way?Many thanksAksel
View Replies !
Sql Server Tools
i just got a free download from www.idera.com. they have a cool freemonitoring tool and some other stuff. check it out
View Replies !
Tools For SQL Server
I'm a newbie in working with SQL Server. Can anybody prompt me some good tools for SQL Server administration and other useful tools for Microsoft SQL Server???
View Replies !
Preferred SQL Tools For Sql*server?
Hi All,I am new this week to sql*server / query analyzer, coming from yearsof an oracle / TOAD background. Does anyone have any tools theyprefer for writing and executing sql code other than query analyzer?Thanks!Mike
View Replies !
SQL Server Administration Tools
I'm searching for some alternate administration tool (permisions, rights,etc.) on sql server, something not so complicated as default. Does anyonehave some info about that? ThanksPete
View Replies !
SQL Server Tools Information
Hi to all Friends, Now a days i have a query regarding SQL Server deployment.Is it possible that on our client side we not install enterprise manager due to some managerial problems.Because we are feeling that using enterprise manager our database design is not save and somebody can copy it.Please help me on this issue. Thanks
View Replies !
Free SQL Server Tools
I designed three freeware applications intended as Administrative, Development, and Investigative tools for MSSQL Server 7 and 2000. Some features include, printable data dictionary, monitor SQL Server in real-time with a very small footprint, see dependencies of data objects, write your own custom Stored Procedures for viewing in the application, plus a lot more! And did I say there FREE! All three applications are safe because they are all read only. Developers, Programmers, Database Administrators and Business Analysts will benefit from these products. At least download and see. ftp:65.32.234.166 login: Hybridx Password: 996tyi Robert Vallee rvallee@hybridx.com
View Replies !
Server Monitoring Tools
I want to know if there are any tools that will allow a DBA to monitor changes that occur on SQL databases (deletion, addittion or modifications) on any objects, and Sql security. I have looked at Profiler in SQL and it is very limited and plus it is huge memory hog and causes degradation on your servers.
View Replies !
SQL Server CE Tools Problem
Hi I had VS 2005 Pro and SQL Server Dev. Ed. 2005 installed. These were patched to SQL Server 2005 SP1 and then VS2005 SP1. Yesterday I installed SQL 2005 SP2. Today I successfully installed the main bits from http://www.microsoft.com/sql/editions/compact/downloads.mspx but the VS tools will not install. It's telling me that the upgrade cannot continue. I think that VS2005 SP1 may already include the SQL CE tools - is this correct? I do not see any mention of this when I go Server Explorer->Connect to a database -Brian
View Replies !
Idera SQL Server Tools
Opinions on Idera?? A rep from Idera came to pitch Idera SQL Server tools. My boss is mostly interested in SOX compliance auditing for relatively few servers. We have some interest in performance monitoring. I am mostly interested in a centralized configuration database to manage 50 or so instances of SQL Server, both SQL 2000 and 2005. Have you tried Idera? Like? Like something else better?
View Replies !
What Tools Should Developers Use For SQL Server?
This may be an intuitively obvious question, and if so, I apologize. Speaking in terms of best practices here, what is the preferred method for allowing developers to work with databases in SQL Server? If they use Management Studio, then they have access to tools for perhaps messing with other databases, etc. that they should not (assuming it is not correctly secured). Likewise with Enterprise Manager. I can see where they would use Query Analyzer, but these two are now combined in Management Studio. I'm just inquiring into how other DBA's do this. I realize there are DBA's that are developers and vice-versa, but what if there is a clear line of distinction and you want to keep the tools used in these roles separate? Thanks in advance. Kevin
View Replies !
How 2 Install Client Tools For SQl Server
In Server Explorer of VS .NET 2003, I tried to generate SQL script of the dbo.Portal (ibs) but got "To use this feature, you must install the client tols for SQL Server" When I searched for Help, I've got "1.Insert the MS SQL Server 2000 compact disc in your CD-ROM drive" I installed and use MSDE and cannot recall the use of any CD for installation. 1) Does it mean that I cannot install client tools from MSDE installation? If not... 2) I have installation of MS SQL Server200 Enterprise that cannot be installed on Windows Xp Professional that I use. Can I still install "client tools" from Enterprise Ed. for MSDE
View Replies !
Management Tools In SQL SERVER 2005
Hi Team, Is there any management tools in SQL SERVER 2005? I just installed my standard edition and also developer version in different computer, but seems that both versions doesn't support management tools such as query analyzer. Can anyone explain to me... Thanks.
View Replies !
SQL Server Client Tools Installation
I'm trying to install SQL Server 2000 client tools on an XP workstation.MSDE already exists on the workstation. During the install I am neverprompted for a location to install to. I want to install to my D drive. Theinstall defaults to my C drive.Any thoughts?
View Replies !
SQL Server 2000 Client Tools
According to MS Knowledge Base Article 269824, "[SQL Server 2000 ClientTools] ... must be installed ... on any computer on which someone may makedesign changes in an Access project to a SQL Server 2000 database".This is the situation I'm facing. Can I download these Client Tools andinstall them for free, or are they only available on the SQL Server 2000Installation CD?Thanks for any help!
View Replies !
SQL Server Replication Utilities/Tools??
I have an urgent need for a customized stored procedure or a third party toolset/utility that has the ability to assess the results of multi-server replication (factors such as success/failure? - integrity checks on business data). Do such products exist?
View Replies !
Conversion Tools For Oracle To Sql Server
Does anyone know of any tools that exist for converting pl/sql packages/stored procs/functions etc... to t-sql equivalents? I know there are tools to go from sql server to oracle, but haven't been able to find any for the opposite direction. Thanks...
View Replies !
Free SQL Server Tools Fixed
Please accept my deepest apologizes! I have fixed all bugs except one that was reported. The only one I couldn’t get to was the international support issue regarding dates. In my haste to get these apps to the people who could benefit for them I neglected to test them properly. Thanks to everyone for reporting the bugs and your patience. I have my website up and all are invited to download the latest versions. www.hybridx.com Robert Vallee
View Replies !
SQL Server 7.0 And MS Access Upsizing Tools
I try to upsize 2 tables from access to sql 7.0. This tables have a relation with referential integrity. I get a error from server with 2 messages: 1st: sp_addmessage 778578,16,'Cannot add or change record. Referential integrity rules require a related record in table "mytable" The second message - server error 15279: you must add the us_english version of this message before you can add the 'Português' version. I did the same thing with SQL Server 6.5 and everything works fine. Any help ?
View Replies !
Tools For Converting MySQL To SQL Server
Hi, I'm in search of a nice tool to convert the database from MySQL to SQL Server 2005, where the schemas of both the DB are different. I just want to move the data from one database to another with column mapping.. Can any pls suggest me a nice tool for this issue? Early reply is appreciated... thanking you VarShant
View Replies !
SQL Server Management Tools Not Installed
>> I was able to solve this. Read the bottom of the post. I just installed SQL Server 2005 Standard Edition and none of the management tools seem to be there. At least they do not show up in Start>>All Programs>>Microsoft SQL Server 2005. All that shows up is the Configuration Tools menu item. I have been searching through the forum and I have found dozens of other threads about this, but none that seem to actually answer the question or give a solution. Some say to delete everything and start over, others say to review Visual Studio 2005 (which takes something like 4 hours to install, and then you still have to install all of the 3rd party tools, so I don't want to do that unless I just have to), and a few others say to uninstall SQL Server Express and then reinstall SQL Server. However, I believe that I selected to install them both at the same time. Anyway, I just looking for some ideas here to get all of this installed. There seems to be some problem here that a lot of people are having to deal with. Are the Managment Tools disabled by default? It seems that in 2005 a lot of the services are turned off by default so I'm wondering if I have to do something to turn on the Management Tools. Best regards, Greg Rothlander I just uninstalled and reinstalled per some threads on the forum and it all showed up. Apperently if anyone runs into this, just uninstall everything that has to do with Microsoft SQL Server and reinstall.
View Replies !
Installing SQL Server Management Tools
I have been trying for 2 days now to get the SQL Server management tools installed on client machines. I'm starting to think it is not possible to do that the way we used to be able to with previous versions of SQL Server. I have installed 3rd party open source software on my own machine so that I can query the database without logging onto the server directly and would like for my co-workers to be able to do the same. As I mentioned we tried the SQL Server Management studio and all we get is a message saying to uninstall all the beta and Visual Studio *** on our machines. We stripped one machine all the way down to the OS and still kept getting that message so I'm guessing it is some new Windows Vista issue that makes SQL Server 2005 client tools completely incompatible with XP. However, we are not going to bow to Microsoft's evil ways and upgrade to their new OS just to use the SQL Server Studio. If need be I will write my own software to workaround this problem. In the meantime, can anyone recommend some good 3rd party tools that will allow us to query the SQL Server 2005 database on a server and preferably one that does not require all other software be removed first?
View Replies !
SQL Server Tools Refusing To Install
Hi all, Having massive problem getting the SQL Server 2005 Management Tools to install on a XP Professional (SP2) computer. So I have no SSMS, Profiler, etc. Neither the files are there, nor the icons. The error in the dialog box is coming back with: "A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the remplate.ini and set the UPGRADE property to the name of the component." The computer would have had SQL 2000 and SQL 2005 Express Edition installed at some stage but both were uninstalled before my attempting to install SQL Server 2005 Developer Edition. Build 9.00.1399.06. After this dialog box the setup fails that component (Management Tools) then crashes, generating a CAB file with all the logs in the C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG directory. The log files seem to indicate an incompatibility between version of files installed and what wants to be installed. Problem of course is that it's probably read this from the registry somewhere, the files physically do not exist. So I have tried the following with no luck: start /wait setup.exe /qb REINSTALL=SQL_Tools90 start /wait setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS start /wait setup.exe /qb UPGRADE=SQL_Tools90 start /wait setup.exe /qb UPGRADE=SQL_Tools90 REINSTALLMODE=OMUS So then I had a look in the registry. Found Microsoft SQL Server 2005 Tools under HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionUninstall{A30965BD-2D4D-45CE-8F04-6A6889818CF1} Is was to deleting the entire subtree, so thought that if I rename the GUID value and even the name that might solve the problem and force an install. Still no joy. So any ideas on how to force an installation of the Management Tools. I then plan to install SQL Server 2005 SP2. I do not think that installing SQL Server 2005 SP2 will reinstall the files, but I could be wrong. So any suggestions on what to wipe from the registry, whether there is a later set of the tools that I can install separately, or how I can force a reinstallation of the tools. Or should I install SQL Server 2005 SP2 and hope it fixes it up? Perhaps I should uninstall the Microsoft SQL Server 2005 Tools using MsiExec.exe /I{A30965BD-2D4D-45CE-8F04-6A6889818CF1} from the registry and then try to install them again? TIA, Victor
View Replies !
Tools Suggestion For Sql Server 2005
Question 1 I want to check which is the best easy to use cost saving tool in sql server which can do a check the performance of a query and rewrite the query with best performance Question 2 Which is the best tool for load testing tool in sql server, which is easy to understand and use. Question 3 Which tool monitors the changes in the server including the dba's activities and send report to the audit team. Qustion 4 Which tool can send notification about the job's failed , backup task failed etc. Question 5 Which tool can suggest the correct index for all the tables Please recommend me a tool for all this which is easy to use + cost saving and their licencing details with their pricing.
View Replies !
SQL Server Express Admin Tools
<!--[if !supportLists]-->What administrative tools/utilities are installed with a "base" install of SQL Server Express SP2 (e.g., ability to issue command-line SQL, GUI's for accesssing/adminstering databases, etc.)? How can I control what is installed? -Kyle<!--[endif]-->
View Replies !
|
TRACKER
