I am working in a secured company which doesn't allow live internet connection, therefore I can't install SSDT using Web Platform Installer and we also don't want to install the intire 2012 client tools.
View 2 RepliesWe have a BI-Stack configuration for server SQL 2012 that includes a gateway server that houses the app, a second server which houses SQL Server DB and SSIS, and a third server that houses SSAS and SSRS. Where should SSDT tools be installed? I assume on the gateway? This is a production environment, so should VS and/or SSDT not be here at all?
View 1 Replies View RelatedI have a file named abc-72015.txt.
I have a package that renames the file from abc.txt to abc-72015.txt
I want to do the reverse. I wan to rename it from abc-72015.txt to abc.txt.
I have a variable named myFileValue with a value of abc.txt.
Can I do this by setting the variable as an expressions and use a function to rename it as abc.txt?
What would the syntax be?
In database projects, VS2015, I want to create some views for me database that will reference another database table using 3 part naming reference.
Works fine in SSMS but when I try and build me project I is throwing up a reference error.
I can't import the other database into this project, so is there a way to suppress the error? I don't really want to exclude these view from the project.
In VisualStudio 2012 in C# projects when you double-click on a identifier (variable name, class name, etc) then all occurrences of that sting in the current file are highlighted.
It doesn't work in SQLServer projects in sql files. It is a shame that although we are in VisualStudio we are still limited in functionality.
Is there a way to enable this feature?
I Can't find the Data Flow Task in SSDT 2012.
Has it been replaced by another task or do I need to do something to make it visible?
Edit: It popped up under my favorite tasks.
[URL]
I have 2 dbs (SQL 2012) - one contains a trigger that is enabled/disabled by a procedure in the other database. This all works fine.
If I create a Database Project solution in Visual Studio 2012 SSDT (or 2013) for both databases, the stored procedure generates a SQL71502 stating that my trigger name can't be resolved.
To recreate the issue:
CREATE DATABASE DbWithTrigger
GO
USE DbWithTrigger
GO
CREATE TABLE dbo.TblWithTrigger(
Id int NULL,
SomeValue varchar(30) NULL
[code]....
-- Test to confirm
EXEC CrossDbTriggerCall
INSERT DbWithTrigger.dbo.TblWithTrigger VALUES(1, 'Blah blah')
In Visual Studio 2012:
1. Create a new solution with a project named DbWithTrigger
2. In project settings set the Target platform to SQL 2012
2. Import the DbWithTrigger db into this project
3. Create a new project named DbCallsTrigger
4. In project settings set the Target platform to SQL 2012
5. Import the DbCallsTrigger db into this project
6. Add a Database Reference in DbCallsTrigger for DbWithTrigger
When you build the solution both dbs build successfully, however there are two warnings. One is easily resolved by replacing DbWithTrigger in the body of the procedure with [$(DbWithTrigger)] (db variable name for the reference) but I can't find out how to get rid of the other. Is it a bug?
just i see a database and a table 'tbl_OutBox_MT' where there is now primary key and have index (non unique, non cluster). and it store almost 3000000 data per everyday. and wipe out data from their and archive all data to other location and broadcast this table 'tbl_OutBox_MT' by mobile operator everyday from morning to evening. but when it perform broadcast it to mobile operator it takes huge time. because this table gather data from different sources (tables) by using complex query and INSER INTO statement and insert into this table.
I need to perform first, my observation is there is no primary key. when i run any complex query into this table it takes huge time and sometimes shows transaction deadlock error.
CREATE TABLE [dbo].[tbl_OutBox_MT](
[TRAN_ID] [varchar](36) NOT NULL,
[OUT_MSG_ID] [int] IDENTITY(1,1) NOT NULL,
[OUT_MSG_ID_TELCO] AS (CONVERT([bigint],((((CONVERT([varchar](4),datepart(year,[PROCESS_TIME]),(0))+case len(CONVERT([varchar](2),datepart(month,[PROCESS_TIME]),(0))) when (1) then '0' else '' end)
[code]....
Hello,
I am trying to upload a database (MS SQL 7) from my machine to a remote location (host company). This company has MS SQL Server 7 running in its machine, so they told me that all I had to do was to connect from my SQL Enterprise Manager. I am new to MS SQL, so I would appreciate if someone can help me to create a connection from Enterprise Manager to this remote SQL Server.
Thanx
Hello again pals, i meet you again to ask an old question i had, but no found answer.
Can i connect to a remote SQL Server thru Internet, lets say from a client like Query Analyzer?
I read to make it using a VPN, but i try to configure it and cant get connected.
I'm using a Win2000 Server or Win2003 Server,
Thanksfull!!!!
There is many people asking for that, i start to think it cant be done! :'(
Hi all developers...
Please help me for connect to SQL server over internet.
What is the connection string in VB6 ?
And what is the different techniques do this ?
Thanks..
When using the Rda Pull/Push methods I need to have an Internet connection. I'm using VS2005 with VB to build my application. What commands can I use to check for and force or establish an internet connection from my pda?
View 1 Replies View RelatedI want to set up merge replication over internet between sql servers located in different cities. Servers have adsl connection. Also I want to start replication witout synchronizing. Actually what I want is starting replication without snapshot because of connection issues. How could I achieve connecting approximately 40 server in this way?
View 6 Replies View RelatedIs it possible to connect to a sql server express over internet or not ?
- I am using a win2003 sp1 server. Freshly installed.
- The server is directly connected to internet.
- For the purpose of the test, I stopped the windows firewall and the IPSec service.
- I stopped SQL server Browser service.
- I find a free port (here : 1401)
- I activated TCP/IP protocol in SQL Server Configuration Manager, and I have selected 1401 as the TCP port in the IPAll sextion of TCP/IP protection (and I remove the '0' of the dynamic TCP Port).
- Restarted SQL server express...
In the sql server log, I get the message "Serveur Server is listening on [ 'any' <ipv4> 1401]"
But I never get an answer from the server.
sqlcmd -S ip_of_the_server, 1401 -U username -P password is working fine if launched on the server. But I always get a timeout error from any PC. Same with a telnet on port 1401.
Any idea ?
-
I create a WebSite onto the internet.
Then I created a database with MSSQLmanager provided by the WebHosting.
I created a Table and put some data in it.
When I try to access the DataBase an Error says: "Connection cannot be opened. On default settings you cannot access a Database Remotely."
What shall I do to configure my Database.
basically I don't know where to go to change configuration of my Database.
In my intranet I would use SQLServerSuraceArea.
But on Internet I do not know.
someone Help.
Did I miss something ?
Hi
Im having some problems setting up sql server so that i can connect to it in my vb program over the internet.
Im using windows xp pro and have IIS installed and using sql server 2005 express SP2.
My setup is as follows:
from phonecable to router, from router to wireless access point and the wireless connects to my computer.
I have tried disabling the xp firewall, and in the sql server configurationi have set the port to 11001, which i have also opened in my router.
There should be a connection to the computer, cause i have succesfully set up an FTP server on a different port.
I have also enabled remote connections, both via TCP/IP and named pipes.
I have tried to use telnet on my IP adress with the port 11001, and it says that i cant create a connection..Are there other settings i should set to get this to work? This has been bugging me for a little while...
Hi guys,
Can somebody tell me where i can find ( or explain me ) the steps to
connect to sql server using the internet. I am using VB6 (SP6) and SQL SERVER 2000
I want to set up asql server on a central location ( PC ) so that 4 different sites can access the data stored
Thanks for all help
grtz Robert
I have a ssas tabular model as a data source in a .pbix-file. I have uploaded the .pbix-file to Power BI Services and it works fine as long as my visual studio project is open. If I close my visual studio project, the objects in Power BI Services will say "The data recievement for this visual information was not successful."
View 2 Replies View RelatedI have several users with an unusual problem with SSMS 2012. When they attempt to connect to a database using the "Connect to Server" dialog box, the connection just hangs. Sometimes after about 15 minutes the connection will be successful. Other attempts simply spin seemingly endlessly. Users experiencing this issue are both running SSMS 2012 on Win 7 Pro (64 bit). The following troubleshooting steps have been tried:
1. When the user runs SSMS "As Administrator" the connections work almost instantly. (Elevating privileges is not a solution in our environment)
2. Wireshark shows that SSMS does not try to hit the SQL server when the user experiencing this issue clicks connect.
3. I can create a new virgin user on the PC and that login experiences the same problem.
4. A complete rip and re-install of SSMS 2012 does not resolve the issue.
I have SQL server 2014 database installed on a Windows 2012 server and SSDT also got installed ( 2013 shell)
I can connect to a database and see all objects using SSDT , but I cannot write any queries or modify any of the objects,
I am new to the SSDT, and this is the first time I am going to configure SSDT to work with SQL Server.
I was wondering if there is a way to take backup or restore the database using SSDT.
View 6 Replies View RelatedI have a SSDT project that intermittently fails with the following error when I try to publish via Visual Studio by double-clicking the publish.xml file...
(330,1): SQL72014: .Net SqlClient Data Provider: Msg 1205, Level 13, State 68, Line 5
Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
(326,0): SQL72045: Script execution error. The executed script:
IF EXISTS (SELECT 1
FROM [master].[dbo].[sysdatabases]
WHERE [name] = N'$(DatabaseName)')
BEGIN
ALTER DATABASE [$(DatabaseName)]
SET READ_COMMITTED_SNAPSHOT OFF
WITH ROLLBACK IMMEDIATE;
END
This is a hyperV client running on my laptop. I'm connecting to the client's VPN inside the hyperV client and using the "runas" method to open Visual Studio to spoof the domain credentials i use on the clients network. This allows me to connect to servers on the client's domain via apps as if I was logged in with appropriate credentials (not sure how to phrase that better). I can elaborate if deemed necessary, but even the client's FTEs are having same problem and they're sitting in the building.
Windows Server 2012 R2 StandardSQL Server 2014 CU6 (12.0.2480)Visual Studio Premium 2013 (12.0.31101.00) Update 4
Windows Server 2012 R2 (VMWare)SQL Server 2012 SP2 (11.0.5058).Here are some observations...
Happens about 60% of the time during the day (I just keep re-running until it deploys successfully)...late at night and on weekends, it doesn't seem to happen with anywhere near as high a frequency.Only seems to happen when I use "Always re-create database" option (don't recall incrementals having this problem...but admittedly I'm not doing many of those as we're still in the full-speed-ahead-development phase)This does NOT happen when I publish to my local SQL Server instance..Deadlock xEvent trace on target instance. Unfortunately it didn't seem to be able to capture all the info and the deadlock graph doesn't render (error below) checking the Single User Mode during the publish. This seems to increase the frequency with which this issue occurs.
We are getting regular SSDT/VS crashes when doing schema compares (source: project, target: server). Sometimes the compare succeeds but around 80% of the time we get a crash.
We are using VS2013 Update 3 and the latest version of SSDT.
Application : devenv.exe
Version du Framework : v4.0.30319
Description : le processus a été arrêté en raison d'une exception non gérée.
Informations sur l'exception : System.Runtime.InteropServices.COMException
Pile :
à System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32, IntPtr)
[code]....
Just wanted to find if there is a way i can install SSDT without a Visual studio Install in the machine?I intend to use sqlpackages.exe which is from SSDT for publishing a dacpac, and do not intend to install any Visual Studio for this purpose.
View 3 Replies View RelatedWe're trying to perform an upgrade test against a copy (backup/restore) of our customer database as target. There are some tables with timestamp column in the database. The way we do this is by having a database project with a publish profile targeting that copy of customer database and then with TFS build server is used to build the database but only to generate a publish script (/p:UpdateDatabase=False) set in the build definition - msbuild argument.
Example of table definition:
CREATE TABLE dbo.CodeTable1
(ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY
,Code CHAR(6)
,[Timestamp] TIMESTAMP NULL);
We would like to have the "Code" column to have CHAR(7), so in the project we modify the table definition:
CREATE TABLE dbo.CodeTable1
(ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY
,Code CHAR(7)
,[Timestamp] TIMESTAMP NULL);
Expecting SSDT build will generate alter script:
ALTER TABLE dbo.CodeTable1 ALTER COLUMN Code CHAR(7);
To our surprise the generated script was:
ALTER TABLE dbo.CodeTable1 ALTER COLUMN Code CHAR(7);
ALTER TABLE dbo.CodeTable1 ALTER COLUMN [Timestamp] TIMESTAMP NULL;
Which will cause error when the script is executed: "Cannot alter column 'TIMESTAMP' to be data type timestamp."
Why is SSDT generating the change script for that timestamp column??
We then try a local build in VS, the issue is not happening, SSDT correctly generates alter script only for the "Code" column to CHAR(7);
Both local machine and TFS Build server are having VS 2013 Update 4- SSDT 12.0.50318.0 installed.
As we tried to troubleshoot further, we found out that it seems it only happens on a restored database from a backup copy of our customer database. It doesn't happen for databases created by SSDT build from scratch or that we manually created. We've tried make sure all database properties are the same as the database that correctly built.
But still if the target database is the one we restored from a customer's copy, SSDT always tries to alter timestamp column (on server build).
In previous versions of BIDS we were able to customize the DataFlow toolbox to incorporate the Oracle Source and Oracle Destination items - however, it appears this is no longer the case in SSDT (no option to customize toolbox). I've installed the 3.0 Microsoft Connectors for Oracle - when I create a new connection in the Connection Manager I can see the Attunity drivers, but under Other Source/Other Destinations in the Toolbox I cannot find the Oracle Source/Destination components.
View 5 Replies View RelatedURL>..n how to deploy (AKA publish) without dropping the users with the DropObjectsNotInSource enabled. With the SSDT September 2012 release I have been testing I seem to be able to ignore permissions and role memberships but not users.In my situation and that of several other folks I have talked to it is a problem trying to manage this. I am thinking of scenarios where there could be (1..n) databases needing the current build (where n is big and not a static number) and need to be updated but the database Users are different for several reasons.
don't have to manually use schema compare to identify objects to drop when we deploy and not drop database users at the target? Because of the dynamic nature of these databases (i.e. 1-n might be on a different release than the current build) we would like to manage security at the source and not the project or post deployment script level.From the MSFT folks is there any hope that we will get a parameter to ignore users when DropObjects otInSource=true in an soon to be released version of SSDT?
I am trying to use Integration Services for something I've never done before; i.e., download a few files from an AS 400 and then turn around an email them to a user.
My basic problem is that I don't know where to start to get the files from the AS400 to a directory on the SQL Server. I have an Iseries ODBC connection configured correctly that will let me get to the files. Do I use a file system task to get the files from the AS 400 or do I use a data flow task? Don't know what task to start with. Once I get the files into a directory on the SQL server I don't think I will have any trouble emailing them.
I know it's a silly question but I've looked at a couple of books without any obvious answer popping out.
Steve Wells
hi all
i have the 2000 adition but i realy want the 7 version
and now microsoft offer as a shareware only the new 2000 to download as a limited pack
my questune is whare can i get the 7 version on the internet as a shareware
time trail or whatever
thanks in advance
I've been experienceing probelms downloading any of the visual studio express tools. I keep getting a site not available error and/or the vwsetup.exe crashes.
Do you have a better place for me to post for this issue?
I'm running Vista Home Premium 32-bit on a AMD Turion64x2 Mobile
Please help!
Dear All,
I am new to SQL I download "sql2ksp3" to my laptop (Window Xp Pentium III) and then I start to setup MSDE:
>> setup SAPWD=pass SECURITYMODE=SQL
After I run this command it gives me the following statment!!!
Setup failed to configure the server.Refer to the server error logs and setup error logs for more information.
Please help me what i have to do to make this stuff works!!
Sincerely
Henok
I am looking for some material for downloading documents from sql
server. I can upload documents in my app but i would also like to
download those files too.
Thank you
Hi,
I want to download data to excel in which each filename varies depending on the day i download them.
Ex.
ExportFile_09272007.xls
Can this be possible?
cherriesh