So, I downloaded and installed SQL Server 2005 Express, and I just can't figure out how to get it to do anything.
I'm accustomed to SQL Server 2000, and I don't see anything familiar.
Where's Query Analyzer? Where's Enterprise Manager? All I see is this "Configuration Manager" stuff, which doesn't seem particularly useful.
How am I supposed to use this software? I feel like they could have tried a little harder on this one.
I am looking for a resource that will speak to the process of how to create a SQL Express database within VS 2005 - create relationships within the Database Diagrams (right now it complains that it does not have a valid dbo user and that I do not have permission impersonate the dbo user - if i tel it to grant me access it gives me the same message) - what security issues need to be considered as far as the SQL Express stuff is concerned. I am also wanting to know what pieces I need to have on my Internet and Intranet web servers so that when I delpoy my .net 2.0 app that the servers will be able to deal with the SQL Express database that gets copied out there? Should SQL Express on the web server be set to windows auth or mixed mode auth? If I choose windows auth does that mean that the ISP (internet server) has to have an NT account created for my web app so that I can connect to the SQL mdf?
I guess I am just kinda struggling with the process from creation of the database to making sure that when I deploy the application that it will be available.
Any help would be appreciated!Thanks,Derek
How do you get started? I downloaded the SQL 7 software and the sample databases, and
did the start program to run the SQL Server Configuration Manager (Local), but what do you do now?
Thanks
Hi to all.I'm trying to transact from an ASP.NET application in a machine with an SQL Server 2005 placed in a different machine. I can connect without problems from my application to the database, but the problems are when I need to transact with it. The error message I receive is "Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool." (at code I'm using the TransacionScope object).On the first machine, where we have the Visual Studio 2005 and the application web environtment is placed, is an standard Windows XP Professional. On the MSDTC configuration I have checked outgoing and the firewall is down. On the second machine, where is placed my SQL Server 2005, I have all the checkboxs checked at the MSDTC Configuration, and I have the Windows Firewall enabled with the SQL Server and the MSDTC as exceptions, with the ports 1433 and 135 as exceptions too. At the SQL Server Configuration Manager I have as enabled the TCP/IP, the Named Pipes and Shared Memory at Protocols for MSSQLSERVER.When I'm using an SQL Server 2000 database the code works fine and I don't have problems.Any one can help me?Thanks in advance.Jesús
View 12 Replies View RelatedAnd now i'm looking for what in SQL Server 2000 used to be:
Management->
SQL Server Agent->
jobs Can anyone help me find where i can add a job in SQL Express please?
Thanks
Well, its a bit embarrasing to have to ask such ignorant questions, but......
I've been using Oracle for a long time. And VERY occasionally I dabbled just a bit into SQL Server 2000.......
I now would like to create a database driven web application, so I downloaded the Express set. And the books online, in the hope they'd be well organized and provide simple straightforward information on how to do things.... If its there, I'm not finding it.
First question: Is there SOMEWHERE online tutorial/information on specifically how to do things? Something for a user familiar with relational databases and design and such, but needing to understand specifically how THIS database product works?
For example, I managed to get the management studio express open. And in "Registered Servers" there's something called Database Engine, within which there's serversqlexpress.
Can I create an instance (or whatever it is in the MS world) OTHER than sqlexpress, and do I need to? I ask because it appears sqlexpress is on my "C" drive, and I don't want it there... There appear to be system databases within sqlexpress, and I presume they'll grow... SO, do I need to get all this off to another disk? And, if so, how? Feel free to point me to the right documentation - I tried the SQL Server 2005 Tutorials, but after going through the "lesson" on SQL Server Management Studio I realized it was geared toward "how to open a window" rather than how to actually do anything... I found another topic in here that pointed to the "Getting Started White Paper", but that doesn't appear to be valid any more. It also pointed to the "Management Studio Express Primer" but that link just throws a 404 error...
And what on earth does the SQL Server Configuration Manager do? I've gotta be missing something that's obvious to the informed observer...
Hi!
I have trouble using Visual C # 2008 EE and SQL Server 2005 EE. Together with SQL Server on this computer, I successfully using VC # 2005 Prof and Web Developer 2008 EE. A VC # 2008 EE, I can not add the new connection to SQL Server 2005 through SqlClient in Database Explorer .. simply because the Change Data Source dialog does not give me this opportunity, offering a choice only MS Access, MS SQL Server Compact 3.5 and MS SQL Server Database File. I note once again that, for example, the Web Developer everything works fine.
(Excuse me, I use translate.google.com)
Hi,
Was trying to open AdventureWorks when i got this error: "There is no editor available "C: Program Flies.....AdventureWorksDW_Log.LDF'
Make sure the application for the file type(.LDF) is installed.
How can this error be corrected? I also have some error on mdf not installed.May i know how should be the initally steps to be done inorder for me to view this database.
And if i do have a database from microsoft access, what are the steps that i need to do inorder to get it export to Microsoft SQL Server Management Studio Express. Please advise as i really new to it. Thanks!
I have never used MS SQL database. I usually create my database with phpMyadmin. But my clinet doesn't have this tool. And they don't have MySQL instead they have MS SQL.
Could I create the data base with phpMyadmin and output that? Then import the data into MS SQL? There is no GUI tool on the server to create tables and data entry.
Hello everyone,
I have got MS SQL express editon 2005, installed on my laptop and want to download MS SQL 2005 With management studio
I have been searching on microsoft's website, Where can i download it ?
thanks
Ehi
I'm at a complete loss as to how to use databases in ASP.NET.
Everything seems to be set up for SQL Express, but I need to use SQL Server 2005. The SQL Server is not located on the same machine as the website. Then there are the databases I can create through Visual Studio 2005, what exactly are these? Are these local, are these via SQL Express, or do these somehow link to the database server? What does it mean to attach and detach?
There are a lot of pieces here, and I don't know how they fit together.
First, can someone help me with an overview of how all this fits together?
Second, how can I use SQL Server 2005, and not SQL Server Express for my data and for membership, personalization, profiles, etc.?
Finally, should I be able to connect to the remote SQL Server database from my home development machine? Do I need to use IIS to do this?
Thanks in advance for your help,
Diane
I have been running SQL Server 2005 Express with the Management Studio Express. I just downloaded and installed the Eval (Trial) version of SQL Server 2005 but have not been able to get it working. Here are a couple of questions:1. Is there a potential confict with having both versions on my machine. I don't want to uninstall express since I may have to do back to it in 180 days.2. Is there a program comparable to the Management Studio for the Eval version of SQL Server 2005?3. How do I access the Eval version? I found the folder where it installed on my C drive but don't know what to do with it.Thanks for any help you can provide.
View 3 Replies View RelatedHi all
I'm a newbie with Visual studio 2005 .Recently i installed it ,AFAIK sqlServer 2005
also is shiped with vs2005.after installing vs2005 i have the following entries in my
StartMenu/All Programms/
1) Microsoft Sql Server 2005
Configuration Tools
sql Server Configuration Manager
Sql Server Error and usage Reporting
SQL Server Surface Area Configuration
2) Microsoft Visual studio 2005
.....
........
Apparently there isn't any ENTERPRISE MANAGER and query analyzer.?
By the way in Visual studio IDE i noticed "Server Explorer" nexed to "Solution Explorer"
but i didn't find any Database entry or "Create New Database" or some thing like this.!!!
Could any one help me.? i want to Create Database, Tables,....
Thanks in advance.
Regards.
I can't tell if the SQL Developer install upgraded the service, but left the SqlExpress version information, or if I'm still really only using SqlExpress.
Also, my intended target is SQL Enterprise, so if I am using SQL Express am I asking for trouble when I go to move the database over? Are the database formats compatible?
I've poked around trying to search for this answer for a while and haven't turned anything up. Maybe I'm searching on the wrong terms...
Thanks,
Geoff
Hi,
I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve.
When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the
Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable)
I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists.
I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference.
Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson.
Thanks,
Ieyasu
HiIm trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express. The XP with the SQL server that i want to connect to is on the local network. Greatful for help!
View 1 Replies View RelatedThis problem only occurs after deployment, not when debugging. In the table I am having a problem with I have an ID field designated as the primary key with the identity increment set to 1 and the identity seed set to 1. There is no data in the table when deployed. I can add records to the datagridview control but when I try updating the dataset I get this error indicating that the ID field already has a value of 1 present. If I close the application and re-start it, the exception no longer occurrs when I update the dataset. I am including the code to update the tables incase something is wrong there. Any suggestions?
Private Sub UpdateMemberTable()
Me.Validate()
Me.TblMembersBindingSource.EndEdit()
Me.TblMembersTableAdapter.Update(Me.ChurchFamilyDataSet.tblMembers)
Me.TblMemberDependentsBindingSource.EndEdit()
Me.TblMemberDependentsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberDependents)
Me.TblMemberContributionsBindingSource.EndEdit()
Me.TblMemberContributionsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberContributions)
End Sub
Hi Guys,
I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help .
i) How do I include image files into this column [Picture]?
ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly?
Your help much appreciated. Thanks.
Paul
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
This is what I have done.
1. Installed VB.NET IDE 2008 and SQL Server Compact 2005. IDE requires upgrade of database to 3.0 version which I allowed it to do. After the database was upgraded, I did an amount of coding work in the IDE and then tried to go back to do more database work in SQL. However the database then could not be opened in SQL Server Compact 2005. An error said that because it had been upgraded, it could not be read. It was requiring me to run 'upgrade.exe'. I had no idea what this meant and could find no upgrade available online.
2. Removed VB.NET IDE 2008 and installed 2005 instead. However, the file extension on the SQL Server Compact database is .sdf, but the IDE is requiring a .mdf extension. I have tried everything I can think of to get it to save or to have the desired extension, but I cannot.
Questions:
1. Do SQL Express 2005 and VB Studio Express 2008 work together?
2. If so, how?
It seems as though application each requires a different version of the database. If the database is usable in one, it is not usable in another.
Thanks for the help.
Julie
I have a 2005 Express DB I wish to attach to using the 2005 Mgt Studio Client (Not the express version, but the full blown 2005 Mgt Studio Client from the SQL 2005 Standard Edition Install disk). Can this be done, or can I only use the 2005 Mgt Studio Express Edition Client?
Thanks in advance.
M. Scott Blalock
View 2 Replies View Related
We are trying to move data from a product called TABLEBase that runs onthe mainframe and we are experiencing problems trying to BCP the datainto SQL Server. The SQL server we are tying to BCP into is SQL 2000.We are using BCP from a command prompt.Here is what happens.the first time it doesn't load anything and we get no messages.The onlyway I got it to work was to run BCP and have it create a ForMaT file.I compared the ForMat file I created by hand,to the ForMat file Icreated from BCP they are identical. (I used a product called beyondcompare to check it). After I created the ForMaT file and loaded thedata, I then deleted the data and ran it with the original ForMaT file(no changes) and the data loaded fine this time.Has anyone else run into this before? It is driving us nuts!
View 6 Replies View RelatedI finally got an SSL cert to show up!!!
But when I try to connect, I get this pesky error message:
provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.
Does anyone know how I turn on ' trusting myself ' or get this to go away?
Hi I'm currently having some troubles formulating an SQL query. The idea is this (in psuedo code): Select * From datatableIf (@input1 = "Hello") Then ( WHERE @input1 = column1 AND column4 = 1 )ELSE ( WHERE @input1 = column1 AND @input2 = column2 AND @input3 = column3 ) Basicly I need it to perform the first filter if input1 is very specific or otherwise perform the the second filter Thanks
View 5 Replies View RelatedHi,
I am having a hard time updating a database row using a UNIQUEIDENTIFIER. I retrieve the row into a datagrid and then use the GUID as a parameter to a stored procedure, but it doesn't update. If I run the query in SQL Analyser ... it works. Any ideas ? Here's my stored proc ... I tried passing a varchar and doing the conversion in the SP ... no go !! I am using MApplicationBlockD.
CREATE PROCEDURE spScanUpdate
@id varchar (100),
@name varchar (75)
AS
DECLARE @GUID_ID as uniqueidentifier
SELECT@GUID_ID = CAST ( @id as uniqueidentifier )
UPDATE tScan
SET name = @name
WHEREid = @GUID_ID
GO
Hi there,
I am trying to code a button that queries a database, and as a result of the query will re-direct a user to a different page. I have put together the following code, but know it is so wrong. Any suggestions on how to develop this would be greatly appreciated! I need it to be done through a button rather than a session etc.
Sub button_Click (ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim myData AS SqlConnection
Dim cmdSelect as SqlCommand
myData = New SqlConnection(ConnectionString)
myData.open()
cmdSelect = new SqlCommand("SELECT payDate FROM tblPayments WHERE userName = Matt", myData)
IF cmdSelect >= Date.Now() Then
Response.Redirect("youraccount.aspx")
Else
Response.Redirect("payment.aspx")
End If
myData.close()
End Sub
Thanks in advance for your help,
TCM
Hi guys I am having troubles writting a SQL query. Here is the situation I have two phrases and I have to do a search on first three letters of each word in the first phrase and see if it matches any word in the second phrase.
For example
Phrase 1: "The Company Corporation"
Phrase 2: "Correy and sons"
This should be a match since "Cor" from Corporation matches with "Cor" from Correy.
Any help....
I'm trying to run DTS packages (import AS400 information) on a job and it fails, but when I program a DTS package job that imports from SQL Server to SQL Server it does not fail.
What can I do?
I hope your answer
Thanks
Cristopher Serrato
I'm having a problem creating a isnull statement.
I want to do two things I want to list all of the accounts that have a null value in a numeric field. And I want to update those accounts to 0.00.
I tried:
select Account_Num, isnull(TotalDDMFEE, 0)
FROM Addr_20080402
But it returned all records
For the update I tried:
update Addr_20080402
CASE
when TotalDDMFEE = ' ' then TotalDDMFEE = 0.00
AND
update Addr_20080402
CASE
when TotalDDMFEE = isnull(TotalDDMFEE, 0) then TotalDDMFEE = 0.00
Any ideas how I should have written these two queries?
Thanx,
Trudye
Hi all,
the system I am working on was upgraded recently from SQL2000 to SQL2005, and it's generating strange issues after then.
The maintenace plan stopped working (the job was going to run forever if I didn't stop them), and I was able after some tests to understand the cause: It's impossible to backup two of the databases I have on the server.
If I try to di it manually I got this:
ERROR 3026
"Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized (...)"
You could think it's because someone is using the DBs at the same time, but I tried to Execute the Plan at night and the morning before it was still there running since 12 hours. If I cut from the maintenance plan these two databases the job runs just fine.
A strange thing, maybe a relevant clue, is that when I go to the tasks-->Backup and the SQL Server suggests a name for the new bak file instead of having a .BAK file (as for the others DBs I have there - something like 10) It tries to put the backup in a .TRN file (the sequence number seems to be correct - I have myDB_backup_200704181200.TRN instead of myDB_backup_200704181200.BAK); what makes me think this is a clue is that all this happens only for these two databases I cannot backup.
Ring any bells?
Thanks in advance,
Cheers,
Giovanni
I have just about figured everything out except for 2 things.
First sometimes there will not be a ‘177’ record. How can I structure my IF statement so I can bypass the code. Other wise it creates a hdr and a blank detail record? Or is there another conditional verb I can use that might be better?
Second I can’t get my cnt to show up in my hdr records. The print statement is not even showing them. What am I doing wrong?
Any ideas?
Thanx in advance,
Here's my code:
DECLARE @Cnt int
DECLARE @Sys varchar (4);
DECLARE @vwSys varchar (4), @vwPrin varchar (4)
/* Define Cursor */
/*Works like an ARRAY*//*holds current record */
Declare vwCursor CURSOR FOR
SELECT Sys, Prin FROM dbo.vwPrin
ORder by Sys, Prin
open vwCursor
FETCH NEXT FROM vwCursor INTO @vwSys, @vwPrin
print '1st FETCH '
Print @vwSys
Print @vwPrin
SET @Sys = @vwSys
WHILE @@Fetch_Status = 0--34
BEGIN
INSERT INTO tblOutput (Batch_Type, Batch_Num, Sys, Prin, Terminal_id, Op_Code)
SELECT DISTINCT TOP(1) '9', @Cnt, Sys, Prin, Term_Id, Op_Code
FROM dbo.tblTrans
WHERE Sys = @vwSys AND Prin = @vwPrin
INSERT INTO tblOutput (Account_Num, Tran_Code, SubTrans, Terminal_Id, Op_Code)--45
SELECT Account_Number, Transaction_Code, SubTrans, Term_id, Op_Code
FROM dbo.tblTrans
WHERE dbo.tblTrans.Transaction_Code = '020' AND Sys = @vwSys AND Prin = @vwPrin
SET @Cnt = @Cnt + 1
Print @cnt
INSERT INTO tblOutput (Batch_Type, Batch_Num, Sys, Prin, Terminal_id, Op_Code)
SELECT DISTINCT TOP (1) '9', @cnt, Sys, Prin, Term_Id, Op_Code
FROM dbo.tblTrans
WHERE Sys = @vwSys AND Prin = @vwPrin
INSERT INTO tblOutput (Account_Num, Tran_Code, Clerk_Code, Memo_Text)--45
SELECT Account_Number, Transaction_Code, Clerk_Code, Memo_Text
FROM dbo.tblTrans
WHERE dbo.tblTrans.Transaction_Code = '115' AND Sys = @vwSys AND Prin = @vwPrin
SET @Cnt = @Cnt + 1
[b]IF (SELECT Transaction_Code = '177' AND Sys = @vwSys AND Prin = @vwPrin FROM dbo.tblTrans)[/b]
BEGIN
INSERT INTO tblOutput (Batch_Type, Batch_Num, Sys, Prin, Terminal_id, Op_Code)
SELECT DISTINCT TOP (1) '9', @cnt, Sys, Prin, Term_Id, Op_Code
FROM dbo.tblTrans
WHERE Sys = @vwSys AND Prin = @vwPrin
INSERT INTO tblOutput (Account_Num, Tran_Code, SubTrans, SubTrans_2, Terminal_Id, Op_Code)--45
SELECT Account_Number, Transaction_Code, SubTrans, SubTrans2, Term_Id, Op_Code
FROM dbo.tblTrans--55
WHERE dbo.tblTrans.Transaction_Code = '177' AND Sys = @vwSys AND Prin = @vwPrin
SET @Cnt = @Cnt + 1
/*Continue FETCH Command until EOF */
FETCH NEXT FROM vwCursor INTO @vwSys, @vwPrin
print ' 2nd FETCH '
Print @cnt
END
--Print @vwSys
--Print @vwPrin
END
CLOSE vwCursor
DEALLOCATE vwCursor
END
We have an application that connects to a remote site's SQL server using aVPN client. It also uses a local MS SQL database located on one of ourservers. It seems once the VPN connection is established the client machineis always looking to the remote VPN connection/server for it's data. Itested this out by going into the ODBC applet and doing a "TEST CONNECTION"with the VPN client closed. The response was immediate and the connectionworked. Once I established the Internet VPN connection the connectionrepeatedly failed after a several seconds while it appeared to be looking onthe Internet for a local server.What can we do to fix this problem.Thanks,Charles MacleanMTS, Inc.
View 1 Replies View Related