Connecting To SQL 5.0 Standard Addition
Jan 7, 2008
I am trying one of the examples from the .NET Framework 2.0 Web-Based Client Development and I'm having a problem authenticating. I'm running everything on my local computer (IIS, SQL 2005 STANDARD ADDITION and Visual Studio). While in Visual Studio (in other words, debug mode) when I run the example, I get the following error:
Cannot open database "pubs" requested by the login. The login failed.
Login failed for user 'DPJ-6E95AFFA416ASPNET'.
This could be more of a SQL question that a ASP.NET question, but I'm not sure. I'm running under the local administrator account, but this seems to indicate that ASP is using it's own credentials to access SQL. This is my first time using these tools, and I'm guessing this is a fairly well know issue.
I was looking for a "User Admin" function in SQL and could not find it, so I'm a bit lost here.
Can anyone help please.
Thanks
View 6 Replies
ADVERTISEMENT
Dec 10, 2007
In my company, all programmers are required to connect to the database through a wrapper class that was written a few years ago by one of the senior programmers. Basically, you call a method, passing the conn string, name of stored proc, and any vars, and that method returns a DataSet which either holds the result set, or is empty.
This means that I cannot use the SQL Server Project option for 2005, along with many other features that are not available due to the wrapper. I was wondering how do people in other companies connect to the db from their asp.net application? I am assuming that the wrapper was written in the days of SQL Server 2000, and that the higher ups do not see a need to change over. Or maybe it was done due to some security policy that I am not aware off. In any case, we are a small group of developers and if enough of us get behind an initiative, management will allow for the necessary changes. I am trying to build my case against continuing the use of the wrapper class. Any thoughts or pointers will be much appreciated. Cheers.
Oh yeah, we are develping on SQL Server 2005 and VS 2005.
View 4 Replies
View Related
May 20, 2006
Hi,
I've been trying to fix this error for two days! and I really need the advice of the experts please!
Computer XP Professional Service Pack2, SQL Server 2005 and Visual Studio 2005 (both Standard Edition)
ConnectionString:
<connectionStrings>
<add name="MyConnectionDB" connectionString="Data Source=(MyServerSqlServer2005);Initial Catalog=MyDB;User ID=sa;Password=PasswordforSA" providerName="System.Data.SqlClient" />
</connectionStrings>
C# code
string myConnectionString = ConfigurationManager.ConnectionStrings["MyConnectionDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(myConnectionString);
myConnection.Open();
Here I get the error: {"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, error: 26 - Error Locating Server/Instance Specified)"}
What I checked so far:
ServerName and Instance Name OK!
Database, Username and password OK!
SQL Server 2005 Surface Are Configuration - Remote connections using both TCP/IP and Pipe Names OK!
SQL Configuration Manager - Protocolos Enabled (TCP/IP, Pipes, shared) OK!
SQL Server Browse running and active OK!
Am I missing something? I never had this problem with SQL Server 2000 and Visual Studio 2003.
Thanks in advance for any help or suggestion you can give me.
Sasa
View 1 Replies
View Related
May 21, 2006
Hi,
I've been trying to fix this error for two days! and I really need the advice of the experts please!
Computer XP Professional Service Pack2, SQL Server 2005 and Visual Studio 2005 (both Standard Edition)
ConnectionString:
<connectionStrings>
<add name="MyConnectionDB" connectionString="Data Source=(MyServerSqlServer2005);Initial Catalog=MyDB;User ID=sa;Password=PasswordforSA" providerName="System.Data.SqlClient" />
</connectionStrings>
C# code
stringmyConnectionString = ConfigurationManager.ConnectionStrings["MyConnectionDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(myConnectionString);
myConnection.Open();
Here I get the error: {"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, error: 26 - Error Locating Server/Instance Specified)"}
What I checked so far:
ServerName and Instance Name OK!
Database, Username and password OK!
SQL Server 2005 Surface Are Configuration - Remote connections using both TCP/IP and Pipe Names OK!
SQL Configuration Manager - Protocolos Enabled (TCP/IP, Pipes, shared) OK!
SQL Server Browse running and active OK!
No Firewall
Am I missing something? I never had this problem with SQL Server 2000 and Visual Studio 2003.
Thanks in advance for any help or suggestion you can give me.
Sasa
View 6 Replies
View Related
Aug 28, 2007
How can i make a sum (concatenation) of strings of one column in a table.
for example i have a table like this
field1 field2
1 abc
1 bcd
2 sdf
2 sdd
I want to get these strings added group by field 1
Thanks
View 5 Replies
View Related
Jan 24, 2001
For an existing table containing data, how would you add a primary key field, that contains a value for each row?
(Under Access I'd just add a new field and set it to type AutoNumber, but you can't do that in SQL Server)
View 1 Replies
View Related
Jan 15, 2002
Hi Everybody,
I hv executed the following query in the Query Qnalyzer
(Ofcourse I am Using SQL 2000 Enterprise Edition) and Surprisingly
I am getting the Output as follows,
query:-
select '5' + 10
Output:- 15
Can anybody please tell me, why it is happening like this? OR Did I miss any Configuration Parameter in the Server Settings?.
Tks in Advance,
Sam
View 1 Replies
View Related
May 12, 2008
Hi
Is there anyway to perform a addition on two items in a COUNT query?
For example if i use the followig query:
SELECT
Region
,COUNT(*)
FROM Regions
GROUP BY Regions
It would give me the following results:
Region1 22
Region2 33
Region3 21
Region4 4
Region5 9
Region6 61
However I would want it display the the combined totals Region1 and Region2 together so it would give the figure of 55.
Is this possible?
Thanks
View 6 Replies
View Related
Dec 6, 2006
i have the idea that 23+null=null
now following is my case with 2 columns as:
salary bonus
1 null
2 5
3 null
i have to find the total salary(i.e. salary+bonus)
this is how i managed to do it:
select empname,(salary + commission) as 'total salary'
from emp
where commission is not null
union
select empname,salary from emp
where commission is null
now my question is,wht if the case now is different as below:
salary bonus hra
1 null 6
2 5 null
3 null null
now how do i calculate total salary(i.e. salary+bonus+hra)
am a beginner
help appreciated
cheers
View 5 Replies
View Related
Mar 22, 2007
hi guys,
I have got something like this,
A S D
Bi Ar 23
Bi Ar 12
As Ar 52
As Ar 11
Ap Jo 24
I Have 3 columns. First 2 columns are Text and the third one is Number. I need to see if any duplicate values are there in first 2 columns. If so then i need to add the values of 3 columns and make it one. So the output should look like this,
A S D
Bi Ar 35
As Ar 63
Ap Jo 24
View 15 Replies
View Related
Mar 16, 2007
Hi I have a query, what I would like to do is create a column that takes the results in two coulms and add them together:
Col A Col B Col C
Row1 1 1 2
Row2 2 3 5
Here is the query
declare @t table( player_name varchar(100), BuyIn int, TopUp int, ReBuy int, Winnings int, Events int, Test int)
INSERT INTO @t (player_name, TopUp)
SELECT Player_name, SUM([Top-ups]) AS TOPUPS
FROM (SELECT Event_data.Transaction_type, Players.Player_name, Events.Top_up, Event_data.Transaction_value,
Events.Top_up * Event_data.Transaction_value AS [Top-ups]
FROM Event_data INNER JOIN
Events ON Event_data.Event_id = Events.id INNER JOIN
Players ON Event_data.Player_id = Players.Player_id
WHERE (Event_data.Transaction_type = 2)) AS Topups
GROUP BY player_name
INSERT INTO @t (player_name, ReBuy )
SELECT Player_name, SUM([Re-buys]) AS REBUYS
FROM (SELECT Event_data.Transaction_value, Players.Player_name, Events.Rebuys, Event_data.Transaction_value * Events.Rebuys AS [Re-buys]
FROM Event_data INNER JOIN
Events ON Event_data.Event_id = Events.id INNER JOIN
Players ON Event_data.Player_id = Players.Player_id
WHERE (Event_data.Transaction_type = 3)) AS REBUYS
GROUP BY Player_name
Insert into @t (player_name, BuyIn)
SELECT dbo.Players.Player_name, SUM(dbo.Events.Buy_in) AS BuyIn
FROM dbo.Players INNER JOIN
dbo.Event_data ON dbo.Players.Player_id = dbo.Event_data.Player_id INNER JOIN
dbo.Events ON dbo.Event_data.Event_id = dbo.Events.id
GROUP BY dbo.Players.Player_name, dbo.Event_data.Transaction_type
HAVING (dbo.Event_data.Transaction_type = 1)
ORDER BY SUM(dbo.Events.Buy_in) DESC
Insert into @t (player_name, Winnings)
SELECT dbo.Players.Player_name, SUM(dbo.Event_data.Transaction_value) AS Winnings
FROM dbo.Players INNER JOIN
dbo.Event_data ON dbo.Players.Player_id = dbo.Event_data.Player_id
GROUP BY dbo.Players.Player_name, dbo.Event_data.Transaction_type
HAVING (dbo.Event_data.Transaction_type = 1)
insert into @t (player_name, Events)
SELECT dbo.Players.Player_name, COUNT(dbo.Event_data.Place) AS Expr1
FROM dbo.Players INNER JOIN
dbo.Event_data ON dbo.Players.Player_id = dbo.Event_data.Player_id INNER JOIN
dbo.Events ON dbo.Event_data.Event_id = dbo.Events.id
GROUP BY dbo.Players.Player_name
HAVING (NOT (COUNT(dbo.Event_data.Place) IS NULL))
insert into @t (player_name, test)
select player_name, ((TopUp) + (Rebuy)) as Test
from @t
SELECT player_name, min (BuyIn) as BuyIn, min(TopUp) as TopUps, min(ReBuy)as ReBuy, min(Winnings) as Winnings, min(Events) as Events, min(test) as test
FROM @t
GROUP BY player_name
ORDER BY BuyIn DESC
--ORDER BY TOPUPS DESC
END
THis is where I attempt to add the coloms but I get a null result
insert into @t (player_name, test)
select player_name, ((TopUp) + (Rebuy)) as Test
from @t
any help would be great.
View 5 Replies
View Related
May 12, 2008
I have a form set-up and am trying to add multiple items in my checkbox to the database; however, the only thing added to the database is the first item checked. Here is the code and any help will be greatly appreciated. Thank you!:<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConConnectionString %>" InsertCommand="INSERT INTO Consultations(FullName, Email, Business, BusinessInfo, Services, Comments) VALUES (@FullName, @Email, @Business, @BusinessInfo, @Services, @Comments)"
SelectCommand="SELECT Consultations.* FROM Consultations">
<InsertParameters>
<asp:ControlParameter Name="FullName" Type="String" ControlId="fullname" PropertyName="Text" />
<asp:ControlParameter Name="Email" Type="String" ControlId="emailTextBox" PropertyName="Text" />
<asp:ControlParameter Name="Business" Type="String" ControlId="bisDropDownList" PropertyName="SelectedValue" />
<asp:ControlParameter Name="BusinessInfo" Type="String" ControlId="businessTextBox" PropertyName="Text" />
<asp:ControlParameter Name="Services" Type="String" ControlID="checkboxlist" PropertyName="SelectedValue" />
<asp:ControlParameter Name="Comments" Type="String" ControlID="commentsTextBox" PropertyName="Text" />
</InsertParameters>
</asp:SqlDataSource>
View 3 Replies
View Related
Nov 14, 2000
I need to up my license limit on a SQL box from 1 to 2 user connections allowed. Where do I do this?
View 1 Replies
View Related
Dec 1, 2007
Hi,
I have several INT columns in a table that I need to update.
For example, in column 'aa' I need to add 2 to all of the values in that column.
I'm using Query Analyzer - what update statement should I write?
View 3 Replies
View Related
Jun 21, 2008
@quantity is the number that the user has input in the txtbox. I want to use this value to ADD together with the current quantity value in the shopcartitem table. I do not know how, my current query only replaces the old quantity with the new .. can someone help me? strSql = "UPDATE ShopCartItem sci SET sci.Quantity" & _
"WHERE sci.ProductID=@ProductID AND sci.ShopCartID=@ShopCartID"Dim cmd2 As New SqlCommand(strSql, conn)
cmd2.Parameters.AddWithValue("@Quantity", quantity)cmd2.Parameters.AddWithValue("@ProductID", productId)
cmd2.Parameters.AddWithValue("@ShopCartID", ShopCartID)
View 1 Replies
View Related
Dec 10, 2013
I've two databases with different structures, i want to add a record with it's data from the first database into the second database in the place i define, this action must happen automatically as soon as the record is created in the first database.
View 1 Replies
View Related
Nov 8, 2007
Hi,
is there a way to perform an addition to the value of a report parameter?
so like Param Value + 1 = 6
where Param Value would be 5?
View 11 Replies
View Related
Feb 2, 2008
Are there any differences between the Developer Addition and Enterprise Addition of 64 Bit SQL Server 05 that would prevent me from testing full capabilities of my production Enterprise Addition in a QA environment utilizing Developer Addition? Any known restrictions on number of DB connections, memory, CPUs etc??
View 4 Replies
View Related
May 9, 2006
How can I check for Null for the amounts if no records are returned in either select. Basically it errors out if one or both of the Amounts return no records. I need to do some sort of IF statement to set one of the amounts or both amounts to zero in those cases so it doesn't error out on me
SELECT (Coalesce(pd1_Amount, 0) + Coalesce(PD2_Amount, 0)) as Amount
FROM
(
SELECT pd.Amount as pd1_Amount
FROM Master m (NOLOCK)
LEFT JOIN dbo.pdc pd ON pd.number = m.number
INNER JOIN dbo.Customer c ON c.Customer = m.Customer
WHERE pd.Active = 1
AND pd.Entered BETWEEN DATEADD(DAY, -DATEPART(DAY, @FirstDayMonthDate) + 1, @FirstDayMonthDate) AND DATEADD(DAY, -DATEPART(DAY, @FirstDayMonthDate), DATEADD(MONTH, 1, @FirstDayMonthDate))
AND pd.Entered <> '1900-01-01 00:00:00.000'
AND pd.Deposit BETWEEN DATEADD(DAY, -DATEPART(DAY, @FirstDayMonthDate) + 1, @FirstDayMonthDate) AND DATEADD(DAY, -DATEPART(DAY, @FirstDayMonthDate), DATEADD(MONTH, 1, @FirstDayMonthDate))
--AND pd.Deposit IS NOT NULL
--AND pd.OnHold IS NULL
AND c.customer <> '9999999'
UNION
SELECT pdd.Amount as PD2_Amount
FROM Master m (NOLOCK)
LEFT JOIN dbo.pdcdeleted pdd ON pdd.number = m.number
INNER JOIN dbo.Customer c ON c.Customer = m.Customer
WHERE pdd.Entered BETWEEN DATEADD(DAY, -DATEPART(DAY, @FirstDayMonthDate) + 1, @FirstDayMonthDate) AND DATEADD(DAY, -DATEPART(DAY, @FirstDayMonthDate), DATEADD(MONTH, 1, @FirstDayMonthDate))
AND pdd.Entered <> '1900-01-01 00:00:00.000'
AND pdd.Deposit BETWEEN DATEADD(DAY, -DATEPART(DAY, @FirstDayMonthDate) + 1, @FirstDayMonthDate) AND DATEADD(DAY, -DATEPART(DAY, @FirstDayMonthDate), DATEADD(MONTH, 1, @FirstDayMonthDate))
--AND pdd.Deposit IS NOT NULL
--AND pdd.OnHold IS NULL
AND c.customer <> '9999999'
) as PDC_Main
View 3 Replies
View Related
Sep 6, 2007
Hi,
I was wondering if you can help.
In my vb.net form I am running a query to insert data from one database table to another.
However what I need to do is to be able is to add the id of a record I have just created to this insert into sql command.
I have managed to use @@ identity to get the id of my first sql insert statement
but I am wondering how I can use it in the second insert into and select statement. At the moment my sql statement just copies exactly what is in the select statement. I can't figure out how to add the @@identity value to my second sql statement.
My second sql statement is a follows:
sql2 = "INSERT INTO ProjectDeliveData(ProjId,ProjDeliveId,RoleId,MeasurementId,ProjDeliveValue, ProjDeliveComments,ProjDeliveYear,FinDataTypeId, FinFileId, ProjDeliveMonthFrom, ResourceId,ProjDeliveDateAdded)" & " select ProjId,ProjDeliveId,RoleId,MeasurementId,ProjDeliveValue, ProjDeliveComments,ProjDeliveYear,FinDataTypeId, FinFileId, ProjDeliveMonthFrom, ResourceId,ProjDeliveDateAdded from ProjectDeliveData where FinFileId=" & strActualFileId
I hope you can help
Cheers
Mark :)
View 7 Replies
View Related
Nov 29, 2004
Dear all participants,
I manage complete online system for two locations, connected via dialup lease line. I have to used merge replication for the same data should be at both locations. It is working fine, I don’t like disturbe it but current requirement is addition of two column in one table which one as also use in merge replication.
How I can add aforesaid columns in table x, column name c1 numeric , c2 character?
What is impact on replication?
Let me know step by step.
Thanks in advance.
Thanks R.Mall
View 1 Replies
View Related
Jan 22, 2005
Can any help me addition of article in runnning merge replication in MSSQL SERVER 2000 with SP3.
Any step by step help is realy great for me.
Thanks
R.Mall
View 1 Replies
View Related
Apr 3, 2004
SQL Server allows addition of two "datetime" values. For example let d1='April 10,2004' and d2='April 11, 2004'. Now when I execute d1+d2 I get 2108-07-20 00:00:00.000. On what logic is this calculation done.
I am actually looking to derive the same result in Oracle. Hence wanting to know the funda behind this.
many thanks.
View 2 Replies
View Related
Sep 29, 2015
My goal is to be able to include test information in the change request that will make the operations manager confident that the change can proceed. Right now all I can think of is to add the index in dev and staging and compare some before and after stats. But I am concerned that an index change might also affect other operations besides SELECTs - such as updates, transactions, or scheduled jobs.
[URL]
View 0 Replies
View Related
May 30, 2007
Hi All,
Good Evening.
I need a comparision between Evaluation copy and Standard license version of SQL Server 2005 /SSIS.
I'm assigned a task to evaluate SSIS and migrate a project to SSIS.
I have downloaded SSIS evaluation version and started working on that.
Now i'm being posed questions for the complete functionality of the tool...
- Whether it has a Bulk load trasformation ?
- Whether the evaluation version contain all the features of a standard license version ?
I need to submit a consolidated report for SSIS in comparision to the current ETL tool features.
Can you please let me is there any considerable features not given with a evaluation copy ?
Thanks in advance,
Suresh N
View 4 Replies
View Related
May 29, 2015
We are using SSRS 2012. Before we were with 2005. Both the versions have the problem. When a change made to parameters (like adding additional parameter to existing report or changing default value of parameter) using visual studio on developers machine and re-deploy to server, additional parameter or changes to parameter is not showing up. So, we are first deleting the report from server and then re-deploying. This works fine. But we realized that we are losing history of the report (like data related to this report run from execution log). We need the history of report. It is very important to top management to see the details.When I searched in forums, users say that it still exist in 2012 and 2014 and every one talks about deleting and re-deploying report. I would like to know if there is any other alternate route to redeploy additional parameter and not lose history.
View 6 Replies
View Related
Aug 2, 2006
How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??
View 1 Replies
View Related
Oct 29, 2007
I have an SSIS package (TransAgentMaster) that I recently modified to include a call to a child package via the file system. The child package creates a text file. When I run the package in dev studio then the child package/text file is produced.
I then imported the TransAgentMaster as a stored packagesfilesystem package into SQL SSIS and executed the package. The child package produced the text file.
I then ran the SQL Server Agent to see if the child package would work and it did not generate the text file. Thus after updating a SSIS package importing the package into SSIS the job that calls the package will not call the child package. Please not that the TransAgentMaster package calls 7 children packages €¦ just not my new one.
Any thoughts why the agent will not run the child newly crated childe package?
View 3 Replies
View Related
Apr 10, 2008
First of all I am planning to install sql 2005 standard and sql standard sp2
on vista ultimate professional using vs 2008 pro
I have some questions about installing sql 2005 what is the best way to install sql 2005 on
vista My article I got this from ms 403393 (upgrading sql standard 2005 to sql standard 2005sp2)
1 sql standard .(shortcut right click from cd/dvd not possible) I have heard command prompt start menu, click cmd
type run D: cd/dvd exe
From a wizard (sql sp2)
2. sql standard sp2
a. upgrade using a wizard
b. open a command prompt (not sure if right click is best option)
install dvd media example dqlserver2005sp2-kb921896-exe SKUUPGRADE=1(is run as administrator option on media)
do I type run or what do I type ?
c. go to system configuration page(where is this) you should see a single warnining you need to install
sp2, the edition should say success if it does not please reapply
d. on the registration page please enter your registeration number
e. on the comments to install please enter database services, reporting services
workstation components, books online and development tools( I wish to install
all components)
f. on the instance page click default instance(default install)
g. finish rest of wizard
h. apply sql sp2
I also have of seperate question of upgrading sql from vista using a Configuring local admin account
account (configuring administration from a wizard-will this notify
me by default) I do not want my administrative priviledges elevated.
I will be using default configurations for my installations.........
I often wish there would a nice picture examples of doing this
Please help
View 5 Replies
View Related
Aug 24, 2007
HI,
may i know the sql server 2005 standard cd is equal sql server 2005 standard volumn license cd ?
View 3 Replies
View Related
Sep 26, 2006
I just want to know which SQL Standard does the SQL Server & Oracle follows?
SQL-86
SQL-89
SQL-92
SQL1999
SQL-2003
View 5 Replies
View Related
Jun 11, 2002
Hiya all....
I've inherited a SQL 6.5 server running on Windows NT 4.0. An application was written (I believe in VB 6.0) to access tables on the server. From the documentation that I have received, I believe that the Security mode for this server is supposed to be "Standard". When I first got my hands on the server, the security mode was set to "Integrated". I have since changed it "Standard" but the users still get the same error:
Connection failed:
SQL State" '08004'
SQL Server Error: 18450
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed. User: MCLEANC Reason: Not Defined as a valid user of a trusted SQL Server connection.
I looked in the Microsoft Knowledgebase and read an article on SQL Server Error 18450 (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q164167). I followed all of their suggestions but the server still seems to be stuck in "Integrated" mode.
Any thoughts would be greatly appreciated.
Thanks
Greg
View 2 Replies
View Related
Nov 20, 2002
Does anyone know if it is possible to go from the Enterprise edition of SQL, back to Standard?
In other words, Enterprise Edition is installed, but what we really want is Standard. Is there any way around this, other than uninstalling and reinstalling SQL?
I assume not, but thought I would check...
View 1 Replies
View Related
