DataSource Controls :: Can't Login Sql Server 2008
Feb 3, 2010
I have sql server ex 2008 installed and I can connect via windows authentication and remote sql server authentication. The problem is I create a login for sql authentication on my sql server ex 2008 using mssms 2008. I simply create a database and a table. Create a login and user name for a DB and check the options. I am worried this wont work as i cant see any issue
TITLE: Connect to Server
------------------------------
Cannot connect to JAGGUY2-1PD810ASQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'jagguy2'. (Microsoft SQL Server, Error: 18456)
------------------------------
BUTTONS:
OK
------------------------------
View 3 Replies
Similar Messages:
Jan 8, 2010
I started a new Sql Server 2008 with mixed authentication Windows and SQL SERVER AUTh... I created a new login account and use it to directly connect in SQL server managment studio BUT... when i create in VS2008 the connectionstring... everytime i try to open the DB connection i take an exception to the login... some screenshots show all the process ;)
LOGIN: admintvmaismais
PASSWORD: ex
Working to connect in SQL SERVER MANAGEMENT...
LOGIN STATUS ON SQL SERVER MANAGEMENTE
Now in VS2008 Web-Config I declare the connectionstring:
<connectionStrings>
<add name="SqlConnectionString" connectionString="Server=JP;Database=tvmaismais;User ID=admintvmaismais;Password=ex;" providerName="System.Data.SqlClient" />
</connectionStrings>
and When i try to open a connection like this:
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString);
try
{
conn.Open();
...
}
catch (Exception e)
{
retorno = e.Message.ToString();
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
}
I get this exception: Cannot open database "tvmaismais" requested by the login. The login failed. Login failed for user 'admintvmaismais'. What am I missing? What do i need to do, to get this login to work?
View 4 Replies
Jun 29, 2010
how can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 Replies
May 19, 2010
is there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
View 2 Replies
Apr 29, 2010
When i tried to attach 2008 database in sql server 2008 it is throwing the error-
"The database 'actitle' cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.Could not open new database 'actitle'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)"
When i execute 'select @@version' it gives 'Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Workgroup Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 'How the version still be 2005 when im in 2008 ..How can i attach my 2008 database back up.
View 2 Replies
Apr 1, 2010
I'm trying to implement a regular ol' out of the box asp.net login system on SQL Server for the first time ever, and it's giving me way more grief than I ever imagined. Everything works great on my local asp.net testing server, but I can't get it working on the web server. I just get the generic- Server Error in '/' Application. A tech at my host mentioned that he thought that it was because I was using an ASPNETDB.MDF file created in SQL Express 2008 on a SQL Server 2005 server. I makes sense but I've seen a half dozen or more possible solutions in the many hours/days I've spent researching this but I hadn't heard of that one.
View 7 Replies
Jun 17, 2010
Migrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 Replies
Feb 25, 2010
Previous developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
View 2 Replies
Apr 2, 2010
I have 5 GB data, when I move from SQL server 2000 to 2008 with Import and Export wizard, my LDF size is increased to 30 GB, Can I reduce my LDF file or move. In my one of the table contain around 20 Lakh data which i have normalized in 2008 and create 4 tables, so my data is entering in normalized form in 2008. But due to size by hard disk is full. I have used shrnik command but it reduce to only 1 GB.
View 5 Replies
Mar 24, 2010
Does anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 Replies
Apr 26, 2010
I have SQL Server Standard 2008 installed on my machine, alongside Visual Studio 2008.
My current hosting provider (not a huge fan) requires me to access my db's remotely via SQL Server Management Utility. To date, I've been doing it by connecting remotely in VS2008. Their troubleshooting documentation/steps, though, are for the SQL Server Management Express 2008, and i'm having a lot of connectivity issues with them.
I followed the steps here: [URL] to "add additional features to an existing installation" - but when I did so, the setup wizard indicated that the Management Tools-Basic were already installed.
View 1 Replies
Apr 26, 2010
The sites that I've got are still in classic ASP. I know this is a good reason to move to .net but I don't want to have to redo all the sites yet.
So here is the problem:
[Code]....
When I have "On Error Resume Next" no erros get posted and everything runs just fine, the pulls from the database work perfectly. But as soon as we take On error resume next we start getting the following erros:
err#424err desc:Object requiredsql:SELECT Name,URL,Title FROM tblMenu WHERE Parent_ID=1 AND Deleted=0 ORDER BY SortOrderScript Name: /index2.asp
View 3 Replies
Feb 11, 2010
I am not used to work with SQL Server(usually I just use express). I run it on windows server 2008, iis7.
I have attached the database to my sql server. I made a web site in iis7 but I get this error message.
Cannot open database "Phaeton.mdf" requested by the login. The login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
Connectionstring I use
<add key="PhaetonConnectionString" value="Data Source=.;Initial Catalog=Phaeton.mdf;Integrated Security=True"/>
View 5 Replies
Apr 22, 2010
I am looking at installing SQL Server 2008 R2 and am curios as to how much of a difference I should expect with it installed on a 32 bit machine vs a 64 bit machine. I have a number of high performance 32 bit machines that aren't being used for anything, and so I assume that I could simply install Windows XP Pro 32 bit on one and sqlServer2008 R2 32 bit and have an inexpensive solution. What kind of degradation in performance should I expect.
View 9 Replies
Jan 8, 2010
I have just installed SQL Server 2005 on windows7. It was installed successfully. When I tried to open SSMS it became faild. It gives me SQL Server Error :18456 Login Failed. How can i find what server name I put to login? Because when It prompt me to login, in server combo box it shows me only <browse for server> option and it doesn't show me any option to select server. I put the default John-PCJOhn it gives me an error. I uninstall it two times and installed it again but every time it gives me same error. It was working fine before formating my laptop. Please give me a solution to login in to SSMS.
View 4 Replies
May 10, 2010
I have been writing c# .net in MVS 2005 conneting to a sql 2005 db, after initial setup about a million years ago, everyhting ran smoothly. Then I upgraded to MVS 2008 connecting to a sql 2005 server. Still all good. Now my IT department FINALLY wants to upgrade the sql server (Stand alone server running on win server 2003 r2). I am wondering if there is a checklist or walk through of steps i need to take to keep connettivity. If I shoiuld build new connection strings for example, or should the current connections be ok to find the server/db/tables provided the server name and permissions haven't changed? Here is a snippit of my config file
...
<remove name="LocalSqlServer" />
<add name="debugConnectionString" connectionString="Data Source=UMAURSQL;Initial Catalog=debug;Integrated Security=true;"
providerName="System.Data.SqlClient" />
...
View 3 Replies
Jan 30, 2010
i could write a query and i could debug forms using both sql server 2008 and visual studio 2008,but i could not connect to the sql server 2008 and test could not be succeded
View 2 Replies
Mar 22, 2010
I have big trouble with impersonate IIS and SQL 2008 . I connect to the iis where I set the ASP.NET Impersonate and I want connect to the sql server with user credetionals . And there is trouble . SQL server run in the win 2008R2 cluster . I try set delegation in the Active directory on the cluster server and in the cluster application .Not work. Connect to the SQL server with anonymous user.
View 5 Replies
Feb 26, 2010
I want to filter by database result based on the current date. I have a grid layout which will display the result based on the current date. I am using parameterized query for getting the result but it is not working.given below is the query i am using
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT TestID, Title, Description FROM aspnet_Test WHERE (Date
=@testdate)">
<SelectParameters>
<asp:Parameter Name="testdate" DbType="Date" />
</SelectParameters>
</asp:SqlDataSource>
and the result should filter on the basis of testdate
String testday, testmonth, testyear,testdate;
testday = System.DateTime.Now.Day.ToString();
testmonth = System.DateTime.Now.Month.ToString();
testyear = System.DateTime.Now.Year.ToString();
testdate.Text = testyear.ToString() + "-" + testmonth.ToString() + "-" + testday.ToString();
but this is not working .It is not showing any error but i am not getting any output.
View 4 Replies
Apr 8, 2010
Ive created a form on my website. what i want to do is when the user clicks finish at the end of the form, i want all that information to be sent to a table that is in sql server. does anyone know a) if thats possible? and b) what code i would need to put in vb?
View 4 Replies
Apr 1, 2010
I have been attempting to install sql server express 2008 but have come across problems. I downloaded it via web platform installer and it ran the install process, and I thought this would be it, but then upon creating some wizard log in controls on a website they won't work because its not installed. Then i relised I can't actually run the program, only some of its features. I then found the Installation centre and thought, oh I haven't actually installed it yet, and when I select new SQL server stand-alone installation or add features, instead of going through the process like it states on tutorials for installs, it asks me to browse for installation media, which I do not have because I downloaded the express edition.
View 3 Replies
Mar 29, 2010
I used that Microsoft Windows installer and installed visual web developer 2008 express and sql server 2008 so I thought. visual web developer works find.
When I look at sql server 2008 all I see is import export data link.
and the configuration tools.
In the configuration tools I see the following:
sql server configuration manager.
sql server error and usage reporting
sql server installation center.
So I figure sql server 2008 was not fully installed.d
I open the installation center and went to system configuration checker but I get a dialog
box that say browse for sql server 2008 installation media.
View 1 Replies
Jan 30, 2010
I have vs2008 . I wat sql server and management tools .
I uninstalled all previous sql 2005 stuff and downloaded SQLEXPRWT_x86_ENU.exe for sql server express 2008.
I followed the instructions from below.
[URL]
I got an error on install when it claims I have a previous ver of vs2008 and need to install sp1 which I have. After installing sp1 I still get same error.
View 3 Replies
Mar 10, 2010
To use: System.Data.Oledb or ADOMD.NET .NET provides connection pooling by default. Can it acheived in ADOMD.NET?
View 4 Replies
Mar 11, 2010
What is the best way to move SQL 2000 to 2008 completely? Please let me know if real life problem generally occurs.
View 4 Replies