Answer Questions
Bill_W trying to drop user from sql server 2005
Hi there. In my master database there is a user called cadmin, im trying to drop this user. I have already deleted the login for this user, however when I try to delete the user from the master database I get an error message saying that this user cannot be dropped because it owns a schema in the database, when I right click this user I can see the schema that it owns but I cant uncheck the schema can anybody please tell me what I have to do drop/delete this user. Im using sql server 2005 Thanks in advance. Go to database_name -> Security -> Schemas -> find the "cadmin" schema and delete it Now you should be able to drop the user See if the user is a database owner, ...Show All
LISA86 Is this a bug?
RS 2005 (SQL 2005 SP1). When you edit the ASP.Net tab (in IIS) for the ReportServer folder and change the Authentication Mode from Windows to None the Report Server will bomb out. Trying to open th ereportserver returns "Report Server is not responding, verify the report server is running and can be accessed from this computer". Changing it back to "Windows" makes no difference, even re-starting the Reporting Service and IIS makes no difference, the report server will not respond. Can some one test this I ended up having to re-install RS 2005....!! What does the venet log / the logs in the log directory tell you HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
PIERCGG could i have missed Reporting services during installation
I recently installed SQL Express advanced and came across something thats confusing me. When i look at my running services i see the advanced features like SQL Server Full Text Search and the like ,but cant seem to find the reporting service. Is there a chance i skipped over it in the insall I had assumed i would have a service running that would say something along the lines of SQL Reporting Services. I havent come across directions on how to turn it on, so i assume that i missed it during installation Have you installed Business Intelligence Design Studio (BIDS) from the 2005 express tool kit If so, were you able to start the application When I try, I get what seems to be sucessful install except wh ...Show All
Johan J Is SQL Server CE really the solution?
Hi, So far, with other programming platforms, I used to have the facility, embedded within application .exe, to: 1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.) 2- Create/access "local"/"Single-User" files for processing purposes. (try to minimize network trafic...) So far, I've read a lot about SQL Server products (SQL Server, Sql Server Express, SQL Server CE), at least all articles I could find, and would like to have your opinion on what would be the best approach 1- What SQL version to use for "multi-user" databases &n ...Show All
MMMalik How to Convert String Data type to DateTime in Derived Column Control In SSIS Package
Hi , I am Using Derived column between Source and Destination Control. the Source input column PriceTime is String Data type. but in the Destination is should be a DATE TIME column. How to Convert this string to DateTime in the Derivied Column Control. I already tried to in the Derived column control PRICEDATETIME <add as new column> ((DT_DBTIMESTAMP)priceDateTime) database timestamp [DT_DBTIMESTAMP] But still throwing Error showing type case probelm Pls help me on this Thanks & Regards Jeyakumar.M If you mean a SQL Server Tmestamp, then that has nothing to do with dates and times. If you mean DT_DBTIMESTAMP, then it works fine for me. Can you be clearer what your pro ...Show All
tcebob Display Dynamic Column in the report
Hi Friends, I need to display dynamic columns in the report. I have to show column list to the end user then he/she will select his usefull column and then I have to display the selected coumn in to the Report. other column should not be visible in the report. Any body know hot to do it Nilay Hi Murali / Nilay, Hope this link will explain you in setting Parameter value. http://www.c-sharpcorner.com/UploadFile/uditsingh/CR1111022006055359AM/CR11.aspx You could easily set up a parameter for each column and then display that column conditionally based on the parameter. For instance, if you have a column that displays First Name, you could have a parameter called Displ ...Show All
Ian Vink For MSFT: Change of behaviour in configurations in SP1???
In SSIS SP1, if you use a .dtsconfig file that references a non-existent object in your package then you get a warning. I don't have a pre-SP1 install to hand so I can't test it out but I seem to remember that pre-SP1 this used to cause an error. Can anyone confirm that this behaviour has been changed in SP1 Thanks Jamie Anyone I seem to remember that you thought the same as me on Friday Oh, and I'll always be younger than you!!! -Jamie Information: 0x40016041 at ConfigTest: The package is attempting to configure from the XML file "C:\Yukon\ISPlaying\ISPlaying\ConfigTest.dtsConfig". Warning: 0x80012017 at ConfigTest: The package path referenced an object that cannot be ...Show All
TA123 Authentication issue
Hello I'm using RS 2000 and although Windows Authentication has been selected on the website and the "Reports" virtual directory, when I browse to localhost/reports I get the report manager with only Home on it and a very limited menu bar whixh exists of home, my subcriptions and help. I can't see any folders. What am I missing Thanks! Are you connected to some corporate network or it is stand alone PC Are you in the Admin group on that machne if not add yourself to the Admintrators group it should solve the problem. I appologize I missed the RS 2000 part. Grant ASPNET (or Everyone) read access to the Report Manager folder. Looks like you don't have ACL rights to the fi ...Show All
charret Your login attempt was not successful. Please try again
I have a standard Login ASP.NET 2.0 control on a login Page, a LoginName and LoginStatus controls on the member's page. once the user login successfully I am redirecting the user to Member.aspx page. The following is my machine configuration Windows XP Pro Service Pack2 IIS 5.1 SQL Server 2000 visual Studio 2005 DISABLE ANONMYOUS ACCESS IN IIS ENABLE WINDOWS AUTHENTICATION I am Using form authentication, and I am getting following error "Your login attempt was not successful. Please try again". To debug,I am displaying the follwoing properties Membership.ValidateUser(Login1.UserName, Login1.Password) : - True HttpContext.Current.User.Identity.Name : - // is blank FormsAuthentication.FormsCookieName : - SqlAuthCo ...Show All
Ben Hall &#40;UK&#41; How to send a report on data change?
I have this report that uses one table. At some random times during the night this table will be updated. Is there a way to trigger the email report whenever the table changes its data Jens, I have to disagree... This will work but only will be available in Enterprise Versions... But this would work also - but needs a little bit "hand-made" customization: http://www.sqlservercentral.com/columnists/jselburg/datadrivensubscriptions.asp cheers, Markus IvanOrdonez wrote: Arent data driven subscriptions triggered by a scheduled routine at a certain time They in fact are and you will have to do some "fancy" things to get it work... But first you will have ...Show All
David465465454 SQL or Visual Web Developer 2005 to arrange phone number formatting?
i am trying to build a database that contains a coloumn of phone number but i reallly dont know where and how i will be able to give a specific format for phone numbers.. or anything else any common type of information that may have a format.. Will i use Visual Web Developer or SQL Server Management or whatever else to arrange my phone number coloumn do you still need help with this if not please mark an answer. thanks, derek for just creating this "special" column in SQL Server you could use SQL Express Mgmt Studio w/sqlexpress ( http://msdn.microsoft.com/vstudio/express/sql/download/ ). the tsql for this is as follows: CREATE TYPE SSN FROM varch ...Show All
Mahesh Gaware How do I determine the IP number and TCP Port of a SQL instance
I'm trying to determine the specific IP address and the TCP port on which a SQL server is communicating. As far as I can tell, I can't use SMO for this, since I need a method that is compatible with both SQL 2005 AND SQL 2000. Is there a work around or can I use DMO Since my target is to be able to use this code against multipel servers, it would be nice to find the method with the least overhead possible. I would also like to avoid being forced to read registries remotely. -- Jakob Bindslet Thanks Jens, If you have multiple ip addresses listening on different ports, the above registry location doesn't show that information. I tried searching for these values in the registry but couldn't find it anyw ...Show All
Torakak Saving a package to the package store vs. SQL Server?
There must be a difference, but I don't know what it is. Can someone please explain the advantages and disadvantages of each method Thanks in advance. MystMan wrote: From what I understand of SSIS. You must have the integration services service/engine running in order to execute the packages. Otherwise, you wouldn't be able to connect to the service itself and run the packages. This isn't correct. According to the books online, the Integration Services Service isn't required to execute packages. As for the MSDB vs. File System thing. Both are managed by the integration services engine, they're just different storage mechanisms. This isn't correct either. With ...Show All
Francois vdv Full text searches and/or CONTAINS in MS SQL 2005
Hiya, I have recently become responsible for a small database for a volunteer soccer league. I am reasonably savvy when it comes to development, but I have not had a lot of experience with administration before. I need to do what I think must be pretty simple: set up full text indexing so I can use a CONTAINS search on a table. The table contains all of the fields the kids use, and each field has a number of divisions that typically play on that field; we use these 'favored divisions' to make scheduling a little easier. Now, one day when I have time, I will set up a proper, normalized, one-to-many relationship between the favored divisions and the playing fields, but right now it's basically like this: fieldID (int, primary key, i ...Show All
jararaca sql 2005 mirroring
i setup sql 2005 mirroring when i run the wizard and start mirroing i get the folllowing error:1418 in the log it says database mirroring login attempted by user NT AUTHORITY/ANONYMOUS logon does not have connect permissions on the endpoint my service acount is LOCAL SYSTEM all 3 sql servers are in same workgroup i can connect with studio to all 3 with no problem any one have any clues here Hi, Refer http://forums.microsoft.com/MSDN/rss.aspx ForumID=227&Mode=0&SiteID=1 Hemantgiri S. Goswami ...Show All