Need to change Authentication type of my first DB in SQL05

SQL Server Setup & Upgrade

Index ‹ SQL Server

- Previous
  - 1
    - Dataflow Tab:There is no ODBC Source option in the Toolbox I need to extract data from tables in a database that I can only access via ODBC. I have successfully created a connection in Connection Manager (ConnectionManagerType = ODBC) for this database. However I＊m unable to add this connection as a Data Flow Source. There is no ODBC Source option in the Toolbox. This is a major because we have been using the system dsn Microsoft Visual Foxpro Driver to access free table directory .dbf files under ODBC with DTS for years. To install a new Microsoft OLEDB driver for foxpro is out of the question on a production system as it would cost many thousands of dollars to go through our BAT testing process How do I extract data from tables in a database via ODBC Thanks in advance Dave Tag: Need to change Authentication type of my first DB in SQL05
  - 2
    - How to create Report Model Project for OLAP Cube Hi , Please tell me how to create Data Source and Data Source View in Report Model Project for OLAP Cube.Whats the provider to use while creating Data Source in Report Model Project to make connection to OLAP Cube. Thanks Raghava Tag: Need to change Authentication type of my first DB in SQL05
  - 3
    - Log files grows indefinitely and causes ETL to fail Hello; I 'm feeding my warehouse through SSIS. When I run a package that does full load from staging to the fact table(which takes 7hrs at least) the log runs out of space. I've added space to the log drive and created a job that shrinks the drive every 10mins but still it does'nt seem to solve the problem. I'm having this problem since I created a primary key column in the fact table. Can anyone suggest if they have encountered this problem before thanks Rok Tag: Need to change Authentication type of my first DB in SQL05
  - 4
    - SSIS - Best way to copy files from one directory to another In SSIS, I was to: take files from c:\directory1 copy them to c irectory2 with a different name (concatenated date on the end) delete them from c:\directory1 Should I be using the Script Task for this I am wondering if I should be using the File System Task which copies directories or files, but I don't know if I could rename the files during the copy. Also, I want the directory names to be in the configuration file. I am not sure how to do this. If I set up a flat file source connection, I need to specify a file name and I just want the directory names. How do I get them in the config file and how to I read them into my script from the config file Linda Tag: Need to change Authentication type of my first DB in SQL05
  - 5
    - MDX - Group By functionality Hello. I am currently trying to replicate a GROUP BY clause in MDX. Basically we have a Many-To-Many Dimension, with Planograms-Items as our hierarchy. When I say: { DESCENDANTS( [Planogram].[PLanogram1], [Planogram].[Items]), DESCENDANTS( [Planogram].[PLanogram2], [Planogram].[Items]) } I get duplicate items since an item is in both planograms, but of course each row has it own sales, units, etc. The problem is, when I submit larger queries I get 30,000 rows, 3,000 of which are unique Item ID's. I've tried a lot, SUM(), using STRTOMEMBER(), etc...but to no avail. Basically i'm looking to sum the rows in which the Item ID's are equal, and only get 3,000 rows back from the cube, with all the non description columns summed. ANy ideas Thanks a lot. Tag: Need to change Authentication type of my first DB in SQL05
  - 6
    - SQL Server 2005 Profiler - Newbie question I need to reverse engineer a SQL Server database in that there is an application that sits on top of the database.. I am trying to understand how certain tables in the database are affected by certain events in in the application.. example on the order entry screen, when an order is placed successfully, what relational tables are accessed Can the SQl Server 2005 Profiler be used to assist with this kind of debugging Thank you. Tag: Need to change Authentication type of my first DB in SQL05
  - 7
    - Parameterized connection string & parameters - problem Hi, I＊ve created a report which utilizes two stored procedures to populate parameter dropdown and fill report itself respectively. Report works fine until I create parameterized connection string. When datasource (not shared) has parameterized connection the parameter dropdown is greyed. I＊m getting error: ＆error during processing of the ConnectString expression of the datasouree ＆name＊＊. It works fine when I＊m using only one stored procedure (no parameter dropdown stored procedure is executed 每 report has only one dataset). It looks like adding second dataset to use datasource with parameterized string spoils something. Any advices are welcome. Tag: Need to change Authentication type of my first DB in SQL05
  - 8
    - SQL Server 2005 Developer Ed Installation On Vista Business Ed 64 This sounds strange. When I have installed Sql 2005 on this Vista Machine and then applied SP2 it kills Vista to the point it wont even start in Safe Mode - It will come back when using Last Known Good Configuration but this leaves Sql Server without the SP2 and it doesnt run very well - Compatability issues and all. Tempted to go back to XP 64 where Sql 2005 ran without a hitch. Vista is a clean install - of course. Anybody got ideas PROBLEM SOLVED Tag: Need to change Authentication type of my first DB in SQL05
  - 9
    - Script Task scripts will not stop at breakpoints. I can not debug any of my scripts. They execute just fine, but if I have a breakpoint set in the script code (in VSA), I get the message: SQL server integration services script task has encountered a problem and needs to close. We are sorry for the inconvenience. If you were in the middle of something, the information you were working on might be lost. Debug Close When I choose "Close" I get this: sMicrosoft Visual Studio for Applications has lost the link to . Your work will be exported to <<my Local Settings My Documents path>> when you quit the application. OK When I click "OK" my package executes normally, but no breakpoints will fire from that point on. Tag: Need to change Authentication type of my first DB in SQL05
  - 10
    - Login failure issue with Crystal reports connecting to SQL Server 2005 Hi All, My application uses "crystal reports" control to integrate some reports that can be viewed from within the application. I'm getting a login failed (due to bad password SQL State 8) error when I bring up the report from within the application. The report runs fine outside the application with the same username password. - I've checked several times to make sure that I'm passing the correct username/password from the application. - All letters in the password are lower case. There is not case-sensitive issue. - I printed the username and password on a pop-up to see what values are passed , and they are correct. - A single test page that uses the same version of "Crystal Reports" control , using the same username/password, brings up the same report works fine. I guess , my question is: Is there a way to trace the login failure event on the SQL Server side to see what is the value of the password that is being sent by crystal reports control I'm using Crystal Reports XI with sp2. SQL Server 2005. I appreciate the help. Thanks, Satish Tag: Need to change Authentication type of my first DB in SQL05
  - 11
    - Parse XML to load files inside them Hi all, is there a way we can parse a XML(file name lister) file that has a structure say, <Node> <Root> <FullName>/My Documents/Documents/Feature/17470_652</FullName> <ShortName>17470</ShortName> <XMLFileName>17470_652.xml</XMLFileName> <LastModifiedOn>12 December 2006</LastModifiedOn> </Root> ... ... ... </Node> and get the values of all the <XMLFileName> attribute and load them into some variables,say here the filename is "17470_652.xml", I have to look for this file in a specified location, open the XML file and load the contents to a table It can be presumed that all the XML files will be stored in a same location Tag: Need to change Authentication type of my first DB in SQL05
  - 12
    - Browsing attributes from shared dimensions Hello, e.g : I have the dimensions order.date , delivery.date based on the dimension date. When i browse the date dimension in the cube browser or in excel, and i select the year attribute from the dimensions it just shows year in the browser and I really want it to show order.year and delivery.year Our real cube has more than 10 shared time dimensions, so it can be really confusing to users when they are browsing , does anyone has an answer Regards, Wout Tag: Need to change Authentication type of my first DB in SQL05
  - 13
    - Cannot connect to SQL Server 2005 Express with Management Studio Express On my home machine without permanent network connections enabled, I cannot get the Management Studio connect to the database server. Always get this error: Cannot connect ot MPLIAM\SQLEXPRESS Additional Information: 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: SQL Network Interfaces, erro: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server) I have used the SQL Surface Area Configuration Tool to reset the defaults to allow remote connections, stopped and restarted the server, but still get the same message. Please help. Tag: Need to change Authentication type of my first DB in SQL05
  - 14
    - password cannot be saved Hi, there; I have a SSIS package which has SQL2005 as its destination. When I setup the connectionmanager, I'd like to use SQL authentication. But I found that the password field cannot be saved (Checkbox "Save password" is selected).Everytime I open the this package's connectionmanager, that password field is cleard. The result is that my C# application that loads that package to execute failed with "Login failed..." Did I do something wrong or anybody know how to save that password field Cheers Tag: Need to change Authentication type of my first DB in SQL05
  - 15
    - Unable to change SQL 2005 database Autogrowth through Server Management Studio I have a database that seems to change its autogrowth settings every so often. When I initially set this up, I set the autogrowth at 500MB. After some time, I noticed that the autogrowth was set to 645000%. When I tried to change it through Management Studio but recieve the following error ' Value of '645000' is not valid for 'Value'. 'Value should be between 'Minimum and Maximum'. Parameter name: Value(System.Windows.forms) This occurs when I try to open it in order to change it. The only way to change it is through Transact. USE master GO ALTER DATABASE mydb MODIFY FILE (NAME = mydb_data, FILEGROWTH = 500MB) GO This will work, but for how long I do not know. I have done this twice before. The first problem is why am I unable to change this value using SQL Management Studio. Second is why is this value being changed and how does such a large value get inputted. So far, this is only happening with only one of my 2005 database. Any direction would be of great help. Thanks Akinja Richards Tag: Need to change Authentication type of my first DB in SQL05
  - 16
    - Sorted Input If a component requires a sorted input it would seem reasonable that you can check the IsSorted property of the attached input, but this will always return false. I have tried this when connecting the output of the Sort transform to my component, and then check the IsSorted property for this input. It is always false. How can this be, and also how can I see if the path is indeed sorted If using a virtual input column in my UI, I get a SortKeyPosition on the columns, but when overriding SetUSageType in the component class I always get zero for the key. Why is the sort information not quite there for me Tag: Need to change Authentication type of my first DB in SQL05
- Next
  - 1
    - While creating a snapshot... Hello, Here's the idea: There is a central SQL Cluster Server and there are branches in different cities. I'll replicate databases from branch SQL Servers to the central SQL Server. Every city will have a database in the central SQL Server. While i was creating publication for replication, i get the following errors from different (6-7) tables among 289 articles. ---------------------------------------------------- 2007-04-20 12:00:45.18 [46%] The replication agent had encountered an exception. 2007-04-20 12:00:45.18 Source: Replication 2007-04-20 12:00:45.18 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException 2007-04-20 12:00:45.18 Exception Message: Incorrect syntax near the keyword 'percent'. 2007-04-20 12:00:45.18 Must declare the scalar variable "@metadata_type". 2007-04-20 12:00:45.18 Must declare the scalar variable "@compatlevel". 2007-04-20 12:00:45.18 Must declare the scalar variable "@lineage_old". 2007-04-20 12:00:45.18 Must declare the scalar variable "@lineage_old". 2007-04-20 12:00:45.18 Must declare the scalar variable "@compatlevel". 2007-04-20 12:00:45.18 Must declare the scalar variable "@p8". 2007-04-20 12:00:45.18 Failed to generate merge replication stored procedures for article 'mf_pro_processeditem_financial'. 2007-04-20 12:00:45.18 Message Code: 156 2007-04-20 12:00:45.18 ---------------------------------------------------- These articles are belong to a software which is developed by another company. Any ideas SQL Version : Enterprise 2005 with SP2 Replication type: Merge Thanks, Eko Tag: Need to change Authentication type of my first DB in SQL05
  - 2
    - Adding linked measures without rebuilding? Is it possible to added a linked measure group without having to rebuild the base cube Or, is it possible to build a cube that exists of nothing but linked measures Tag: Need to change Authentication type of my first DB in SQL05
  - 3
    - How to export to a fixed width flat text file with row delimiters? We're having issues exporting a set of data from SQL to a fixed width flat text file by just doing a right click on the DB, then choosing Tasks > Export Data. You can not specify a row delimiter when you choose a Fixed Width format. The only way around this that we've found is to specificy char(13) and char(10) at the end of the SQL select statement. Without row delimiters you end up with 1 giant record rather than 20,000 regular sized records. Is there any other way around this that we're missing Using Ragged Right is not an option either since the record lengths will be inconsistent if the last field doesn't contain a consistent length to the data. Thanks, Mike Tag: Need to change Authentication type of my first DB in SQL05
  - 4
    - error running ssis package I run an ssis task with right click in the BIDS. the task transform data of the tables between sql2005 DB to another sql2005 DB. this is the error I get: Code Snippet An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: " TCP Provider : The semaphore timeout period has expired . ". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}" . Task failed : CopyTables2 i have a similar task, only diffrent tables that being transfered, same settings. this task run succesfully. for the task that fails it takes a long time to run (something like half an hour, maybe more) and then it falils. the task that succeeds finish fast (something like 5 minutes). the data in the tables that being transeferred in the good task is much smaller than the data in the tables in the failed task. Anyone knows the reason to the error. Thanks. Tag: Need to change Authentication type of my first DB in SQL05
  - 5
    - Recursive Multi-Level Query using CTE. Attn: Experts! I am attempting to do the following.... I have standard tree setup. The tree can be up to 4 nodes deep. User permissions may be assigned at any level in the tree. Any permission should cascade down the tree to the lowest child node. For example, if a user had a role of 1 for the root node (101), the sql should return: OrgID RoleID 101 1 102 1 103 1 etc... My table structure is as follows.... Org OrgID ParentID 101 Null 102 101 103 101 105 102 106 102 107 105 108 105 109 106 110 106 111 106 UserOrgRole UserID OrgID RoleID User1 101 1 User1 102 2 User1 103 2 User1 107 2 User2 101 1 User3 106 3 etc... What I would like to retrive from the above table data is.... OrgID RoleID 102 2 105 2 106 2 107 2 108 2 109 2 110 2 111 2 This is so because all the nodes (except for 101 and 103) are somehow decedent from the 102 node and 102 has a roleid of 2. I am only concerned with the RoleID 2 and User1. I have worked for two days trying to figure out how to do this. I am not a DBA or SQL expert by any means. I cannot seem to figure out how to traverse multiple levels of the tree. I have been using the new CTE and made some progress, but I think I reached my plateau and haven't been able to get any further. If someone could help me, I would be forever in your debt! I am really starting to get very frustrated and I know there are some of you experts out there that would know exactly what to do. thanks! Tag: Need to change Authentication type of my first DB in SQL05
  - 6
    - Need urgent help on Aggregate Function Hi, I need to do something similar to Proclarity in SSAS 2005. In Proclarity i can create a named member by selecting a few members from a dimension. The underlying mdx looks like this Aggregate ({ [Channel].[Channel].[CON - Contractor], [Channel].[Channel].[DIS - Distributor], [Channel].[Channel].[END - End-User], [Channel].[Channel].[GRP - Group], [Channel].[Channel].[OEM - OEM], [Channel].[Channel].[PLA - Private Label], [Channel].[Channel].[SER - Service Provider], [Channel].[Channel].[SYS - System builder] }) Once i select the named member all the calculated measures reflect the result based on the members selected in the aggregate function. How can I do something similar in SSAS 2005. I dont want a named set and calculated member does not work if i use the plain mdx as above. But i also tried using Aggregate ({ [Channel].[Channel].[CON - Contractor], [Channel].[Channel].[DIS - Distributor], [Channel].[Channel].[END - End-User], [Channel].[Channel].[GRP - Group], [Channel].[Channel].[OEM - OEM], [Channel].[Channel].[PLA - Private Label], [Channel].[Channel].[SER - Service Provider], [Channel].[Channel].[SYS - System builder] }, [Measures].Orders Received Local) just to try to to see teh behaviour but to no avail. after processing the cube and selecting this meausre shows up empty cells. How can I solve this problem. thanks in adavance for helping Tag: Need to change Authentication type of my first DB in SQL05
  - 7
    - Problem: Formatting The Sql Report I created a report using SQL Report Server project. I was able to retrieve my data without any problem. I am having a hard time to format the data correctly: when somebody access the report he will have the option to export it to PDF file Here is how I would like to format the PDF File: Test (title) Department : A Mike Jebson St Address State City 14111 NC Test 12541 NC Test2 Page 1 For the second user I will have all the above template to be Repeated again ------------------------------------------------------------------------------------------------------------ Test (title) Department : B George Jebson St Address State City 14111 NC Test 12541 NC Test2 Page 2 I could not make it to copy the title in the second page. This is what I have so far ------------------------------------------------------------------------------------------------------------ Test Mike Jebson St Address State City 14111 NC Test 12541 NC Test2 Department : A George Jebson 14111 NC Test 12541 NC Test2 Department : B Steve J 14111 NC Test 12541 NC Test2 I want the whole template to be repeated for each user. I do group by name but still I can＊t repeat title and the lines for each page. It will put everything under one title. Is there a design screen for pdf Or i just need to do everything in the layout tab for the report then expor it as a PDF Tag: Need to change Authentication type of my first DB in SQL05
  - 8
    - Guidelines for choosing collation If I am doing a fresh installation of SQL 2005 for a new application which will utilize database engine, report server and analysis services is my best choice Latin_General_BIN2 Thank you, Alex Ivanoff Tag: Need to change Authentication type of my first DB in SQL05
  - 9
    - SQL Server 2005 Install fails on Vista During the install, I get the following message: Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt. I cannot uninstall 2.0, as its part of the Vista. I have tried repairing it. I tried downloading 2.0 and installing it, but it says that its allready installed. I was able to install Visual Studio with Sql Server 2005 express. I am stuck. Is the case that Sql install dosent know about the latest version of 2.0 that came with vista Tag: Need to change Authentication type of my first DB in SQL05
  - 10
    - New features of Reporting Service in SQL 2008 Where can i find the new upcoming features in reporting service for 2008 Tag: Need to change Authentication type of my first DB in SQL05
  - 11
    - roll back in for each container Hi, I'm using data flow as flat file source -> derived column ->Data Conversion-> oledb destination I have a fifty thousand record in a delimited file. while processing i got error in 45000th row. In database only 40000 records are there(why is there no all 45000 records). Is there any way to roll back all the 40000 records. Tag: Need to change Authentication type of my first DB in SQL05
  - 12
    - SSRS 2005 probplem with mdx prameter passsing hi , i am trying generate a report using following query. but the parameter is nt properly passing. (OLEDB). i need to correct it. pls help me. ="WITH "+ "MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'"+ "SET [FilteredBUList] AS 'descendants((STRTOSET ( '{" & Join(Parameters!BU.Value,",") & "}', CONSTRAINED),[Account〞BillingCodeDsc].[Billing Code Description],leaves) ' "+ "SET [CustomTimeSet] AS Descendants([Date〞Fiscal].[2006].[Quarter 1]:"+ "[Date〞Fiscal].[2007].[Quarter 4],[Date〞Fiscal].[month],Leaves)"+ "SELECT "+ "{[Measures].[Amount]} ON COLUMNS,"+ "{ [FilteredBUList] "+ "}on rows"+ " FROM Profitability" That BU parameter is multi value parameter. query should accept multi values . Tag: Need to change Authentication type of my first DB in SQL05
  - 13
    - SSIS SCript Transform Parallelism Hi, I need some urgent help on a conceptual question. Requirement: I have a simple package with one dataflow task. In that I need to read from a sql table and for every row in that table loop through n times and generate new output rows based on certain conditions (which are best evaluated in custom script as they are rather complex). Hence, if I have 100 rows in the table as my input, I may end up with 100*n rows as output. My Design: To implement this I have used an OLE DB Source which outputs to a Script Transform (ST). In the ST I intend to loop through in custom code and generate new rows using the .AddRow feature when I need new rows. This ST then feeds into another OLE DB Destination which writes the data to the table. Simple! I am using the default buffer settings. All I have tweaked is the Synchronous... property on the script transform (otherwise I do not get to the Output0Buffer within the script!). Problem: I wish to do as much as possible in parallel. So I would expect the OLE DB Source to provide more than one row at a time to the script transform and that should process more than one input row simultaneously. It seems the script componenet is serializing input, so it seems to take one row at a time from the OLE DB source, loop through and process in the script transform). AM I RIGHT IN THINKING THAT THE SCRIPT TRANSFORM IS EXECUTING THE INPUT IN A SEQUENTIAL MANNER CAN I PARALLELISE THIS If so, how Thanks, Tirthankar Tag: Need to change Authentication type of my first DB in SQL05
  - 14
    - SQL Server Express authentication mode greyed out Having problems connecting to SQL Server Express using 'sa' account and having read threds re problem and MS, advice is that Authenticaion mode needs to be set to both Windows and SQL. I have studio express installed and go to Security from the properties of the Server to change this option to use both authentication modes, however the options are greyed out! Can anyone advise pse. And will amending this option help me to enable the sa login which is refused at the moment, error as follows: Login failed for user 'sa'.The user is not associated with a trusted SQL Server connection Thank you in advance Tag: Need to change Authentication type of my first DB in SQL05
  - 15
    - how to call a stored procedure in SSIS I have to transfer data from source to destination using stored procedures result set. There might be some more transformation needed to store the final result in the destination table. Appreciate an early feedback. Qadir Syed Tag: Need to change Authentication type of my first DB in SQL05
  - 16
    - change the background color in table in report I have a table that i need to display data for each row I want the background color to be diff anybody knowhow to do it color blank color blank Tag: Need to change Authentication type of my first DB in SQL05

kcoleman

* I was able to configure and install the DB

* I accidentally selected Windows Authentication

Now it won't let me login and keeps giving me an error.

Question: how do i change the authentication type without getting into the db is there something I'm missing

Top

Re: Need to change Authentication type of my first DB in SQL05

Arnie Rowland

The authentication method is Server level, not database level. (Are you able to access the Server -but not a specific database )

IF so, using SSMS, in the Object Explorer pane, right-click on the Server, and then select the [Security] tab. Change the authentication method there.

If you are not able to access the Server using SSMS, it may be just as quick for you to re-install (or) let us know so we can walk you through the process.

Top

Re: Need to change Authentication type of my first DB in SQL05

Vidhya Sagar

Sql service is necessary after changing the authentication mode on server level. Hence do a restart after changing the authentication mode.

Top