I currently install SQL server 2005 CTP and I couldn't find the diagramming tool which used to view the conceptual model of the database structure, relationships and entities visually. This diagramming tool feature is available in SQL server 2000, however I couldn't find in SQL server 2005. Anyone would like to give me some recommendations or show me where this feature is hidden?
View 1 Replieshi all,
There might be no upgrade path for our ETL investment. So most of us will be doing redesign and a lot of reverse engineering activity for ETL.
Do any one have a bright Idea to model, diagram or document the exisiting ETL investment.
thanks,
joey.
Hi,
I just want to ask, is there a tool that can create a diagram supporting the SSIS package I have created? I would like to know if there is any available tool that can do this task so that I can support my SSIS package documentation.
For example, I have created a Data Flow task that transfer data from a source database to SQL server 2005 destination. I would like to create a diagram that summarizes the task it perform from source to destination automatically. My purpose is that whenever DB users check my SSIS package, they will have a concise idea of how my SSIS package works through my diagram.
If ever you have any ideas about this, please help.
Thanks in advance.
Hi,
I have Cognos 8 as BI-tool installed on a Windows 2003 Server, both 32 bit. We are thinking of using a 64 bit SQL Server 2005 with 64 bit Windows 2003 Server as database server for a new data warehouse.
Can I use the 32 bit SQL Native Client on the Cognos server for connecting to the 64 bit database server? If not, how should I set this up?
Thanks in advance for your help.
Kind regards,
Albert de Ruiter.
Hello,I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:---There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer"connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"providerName="System.Data.SqlClient" /></connectionStrings>ABC is a mock :)Could anyone pls help? It is much appreciated.
View 4 Replies View RelatedCan someone tell me if I can use the Gui tools which come with SQL Server 2005 against 2000 databases ?
View 1 Replies View RelatedHi,I was wondering if someone could help advise me.Basically i have a client who wants to upgrade from a desktop msaccess solution to a web based system using MS SQL Server 2005.Basically their main concern is in losing the ability to write ad-hocqueries using the MS Access query manager. I can obviously writestatic reports etc but whats the best way to give them someflexibility ??Can anyone advise me if there is any product that can do this for SQLServer 2005 (which im sure there is) but will work in a webenvironment.Or does anyone have any helpful ideas ???all help / advice greatly appreciatedCG
View 1 Replies View RelatedHello,
I need a tool that will let me model a SQL Server 2005 database and then generate the tables, constraints, etc. from the model. I've never used a modeling tool so my knowledge is quite limited. I don't need to model or reverse engineer an application - my sole concern is on the SQL Server database side. I'm not concerned if the tool integrates with Visual Studio. And, of course, price is one consideration.
Are there any good tools that I should look at?
Thanks,
BCB
Hi guys,
I am using DLinq with SQL Server Express 2005 and I need to install some kind of user interface which shows me a trace of the SQL statements sent. I would like to see them in real time (I won't like to inspect a log after :-).
I remember that there was something similar in SQL Server 2000 full edition, but I requiere the same functionality in the Express version now.
Could you tell me if there is some tool to do that?
Thanks in advance,
Erich.
Back in July I released the (then) latest version of SsbAdmin. For you who
don'r know what it is; it's a tool which allows you to graphically administer
SQL Server Service Broker.
I have now uploaded a new version which is compiled against the released
versions of SQL Server 2005 and .NET 2.0.
You can download it from here: [0].
After download, un-zip to some directory and read the README.doc file.
[0]: http://staff.develop.com/nielsb/code/ssbadmin.zip
Hi, I have a field in database that keep the image location. How to display the image in the report ?
Any idea.
Thanks.
I installed SQL Server 2005 Express Edition, I can login to it just fine using SQL Server Management Studio Express. I ran the aspnet_regsql and it created the aspnetdb database. But when I try to test the AspNetMembershipProvider or go to the Security tab in the ASP.NET Web Site Administration Tool it does not work. I have tried messing with the connectionString of the LocalSqlServer in the machine.config, but to no avail. My SQL Server is installed on the Default Instance. Can someone help me get ASP.NET Web Site Administrator to work with my SQL Server 2005 Express Edition?
View 1 Replies View RelatedJust wondering if there are any tools available for SQL Server 2005 which allow the comparison and scripting of data and schema between two databases. This is so that I can migrate between Dev, QA, and Live easily.
A free tool would be best please..
Thanks in advance.
Gaj
I have SQL 2005, and Reporting Service has been uninstalled and reinstalled,
go through each step of confiugration until Encryption Key, for some reason,
the backup button is grayed out, only "restore" button is clickable, as well
as Delete, but we never backup the key before, so this is really strange
since we do not have backupkey, so we cannot restore.
we tried "Delete", then we got the following error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted
value for the "LogonCred" configuration setting cannot be decrypted.
(rsFailedToDecryptConfigInformation)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
Browse report manager and reportserver also got the same error, run
rskeymgmt -d, does not help either
Any suggestion?
Thanks
Don
I have just downloaded VB Express, that comes with SQL Express
In order to manage and use SQL databases it seems I have to use SQL
Studio Mgt Tool. But, where is it? I can only see Configuration Tools,
but not any Mgt tool or DB Engine......
Maybe my installation is incomplete?
thanks
Hi guys, I've tried to back a database from a server on the net ie: discountasp.net by using Microsoft SQL 2005 Express management tool.
After all the set up:
(1) the part "Destination", in the "Disk" radio button was cheked, the path for the backup file shows like: D:MSSQL.1MSSQLBackupmyDatabase.back; As I understand D: is the CD drive(?), so I put a CDisc in the drive, and kept going with the process. The Process went very well and inform that the Database has been fully backed up. But I never have found the "saved" or "backed up" that I backed up. Can anyone show me where this backup Database in that D: drive, and where is that D: drive anyway?
(2) In that "destination" part, if I clicked "add", and then typed in the path address part like: C:....mybackupDatabase.bak for example, the the tool gave me the error: ... not set to an instance ...; I counldn't even select the Browse to browse to the directory that I wanted to back up the Database.
Please help me for this.
Regards.
Joey
How can I add a reference to the Microsoft excel 2003 in the script tool in SSIS 2005? I need to automate Excel for formatting.
Thank you.
Dan
is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??
View 1 Replies View RelatedI have an environment of SQL Server 2K5 and 2000 servers. The environment is mostly data warehouse than transactional. There are some applications working continiously to provid reports. The servers must be up and running.
I have to provide high availability, monitor performance, and minimize down time. Is there any "really good" tool for a DBA for this environment? I would like to hear your experience with the tool you are using. Any practical suggestion is highly appreciated.
Thanks,
[1/29/07] It's first time on this forume for me that I had no reply for about 4 days! Any idea? Any experience to share?
Quest Software has released a SQL Server version of its highly popularOracle tool - TOAD. It is freeware! You can see more about it athttp://www.toadsoft.com/toadss.html and download it athttp://www.toadsoft.com/toad_ss.zip.
View 2 Replies View RelatedHi
I am facing problem with installing SQL Server CE Server Tool,
I have installed SQL Server 2000 SP 4 which is working fine.
While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.
I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue.
Help me please.
Thanks in advance.
Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)
Hi,
I have installed "SQL Server 2000 SP 4" to SQL server and it is running fine.
But when i install the "SQL Server CE version 2.0 Update for use with IIS and SQL Server 2000 SP4", i get below error:
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.
When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I have go thougth few articles in the forum, try to open the sqlce20sql2ksp4.exe file and then run only the MSI, but still fail.
By the way, i found that the sqlce20sql2ksp4.exe does not include any MSI, it is a direct executable file.
Appreciate if anyone tell me the solution.
Thanks in advance.
Best regards,
Plane.
Hi
I am facing problem with installing SQL Server CE Server Tool,
I have installed SQL Server 2000 SP 4 which is working fine.
While i am running Setup of "SQL Server 2000 Windows CE Edition version 2.0" ,Developer tools installed successfully but incase of SQL Server CE Server Tool i am getting following Error
"SQL Server CE Tool is compatible only with SQL Server 2000 Service pack 1 and higher.When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000 , ensure the installer for SQL Server CE Server Tools corresponds To the version of SQL Server 2000."
I am sure that i have running SQL Server 2000 SP 4 (MSDE also SP 4) , IIS (Version 5.1) is also working fine , and one more thing i am trying to install SQL Server CE Server Tool setup is "sqlce20sql2ksp4.exe" (Which i downloaded from microsoft site.).Here all the requirement is fulfill but i dont know what is going to wrong.
I wasted my 2 days behind solving this issue , now i am tiered ,So please any one have solution for this issue.
Help me please.
Thanks in advance.
Regards,
Ketan Gohil
(ktn_nt@yahoo.com,ketan@narolainfotech.com,gohil.ketan@gmail.com)
Hi my server people have informed me that there is a tool that I can access the server with. Can anybody point me in the right direction?
Many Thanks
howlinhuskie
Can anyone recommend a good tool for administering my database ? It is located on a hosting service, however, they donot allow the use of the SLQ server admin tool since there are security concerns..
View 1 Replies View RelatedHello,
I am looking for an ASP.NET tool that allows me to access a SQL Server remotly. We have created a database and would like to begin populating the tables before development of our site. The main funtionality I am looking for is to be able to view all tables within a database in the SQL Server. Also, I would like to be able to insert data into these tables. Is anyone aware of a tool like this?
Thanks a lot!!
HI Everyone,
I need to ask you a question about T-Sql Debugger. I have installed the sqldbreg.exe and sqldbg.dll in the program filesmicrosoft sharedsql debuggin directory. What I need to know is how to access this tool so that I could debug my procedure I have written in sql server 7.0
Thank you so much!!
sj
Hi
Thanks for help me!. I was working the last 3 years with the 6.5 version, and now i`m moving to version 7. I need to know if there is any simple tool like the MSQUERY from 6.5 version, to make simple changes in a easy way, or all querys must be made using commands ?
Sorry by mi English!
Does anyone know of a web based tool that allows a SQL Server databaseto beadminstered from the Internet? (in php)
View 2 Replies View RelatedHi,I want to connect to Sql 6.5 server database server, What clientToolshould I use to connect it?And also Is it possible to update records in the Sql 6.5 usingADO.net 2.0?Thansk In Advance
View 2 Replies View RelatedIm trying to install the SQL Server Compact Tools in Windows Server 2008, but the installation program wonīt let me continue since it says that I must install the IIS Backward Compatibility Tools. The problem is that I canīt find where I do that.
I know that Windows Server 2008 is not listed as a supported os for the server tools, but surely I must at least be able to install them?
I just ran the utility without any commands ant the wizard has come up. This is all independent of my web application.I am guessing this is going to install the database tables to my existing database. UPDATE: They have been createdWill I then connect my web app to this database schema that is created?How do I change the membership/roles users in my web app to point to the database tables?
View 6 Replies View RelatedHi, I'm looking for a tool to compare 2 sql server database and makes a script of the differences (like an added table or record). We want to use it to generate a script which we can send to our customers to update their database if a change has been made. Example: We send our customers database A. After half a a year they request some changes to be made to the application that affects the database, say a table has to be added. We want the tool to automatically detect the difference between database A when it was first released and after the changes has been made and generate a script. Anyone suggestions? T.I.A., ratjetoes.
View 1 Replies View Related